Excel链接mysql数据库

福尔摩斯对我笑 2019-01-03 19320 次 3178条
  1. 下载按照mysql
    首先要下载并安装mysql数据源。下载地址http://dev.mysql.com/downloads/connector/odbc/5.1.html    注意:请选择跟自己电脑型号相对应的软件进行下载。下载后直接一路text安装。
  2. 打开开始菜单,直接在搜索框里搜索ODBC数据源,直接打开
  3. 进行软件配置

  4. 填写配置信息。前两个选项可以随便写。然后按具体情况填写servlet,mysql用户名和密码以及数据库名称。数据库名称是你mysql数据库里真实创建的数据库,配置好了点击“test”。

  5. 打开excel,选择数据>自其他来源>来自数据连接向导>选择ODBC>就可以看到刚刚创建的数据库名称。就说明已成功
标签:

非特殊说明,本博所有文章均为博主原创。

头像也是LOGO
未来博客 博主大人
到了这个年纪,不应该再彷徨!

yeezys进行回复 Cancel Reply



 


已有 3178 条评论 1


  1. kd 10

    My husband and i felt very delighted when Edward managed to do his web research through the entire ideas he grabbed through the weblog. It’s not at all simplistic to simply be handing out techniques that other people have been making money from. And we do know we have the blog owner to be grateful to for that. Most of the explanations you’ve made, the easy blog navigation, the relationships you can help to foster – it’s most extraordinary, and it’s making our son and the family consider that this subject matter is interesting, which is really essential. Thank you for all the pieces!

    回复 2019年10月24日
  2. jordan store

    I must convey my affection for your kind-heartedness in support of visitors who really want help on this topic. Your very own commitment to passing the message all through had been incredibly informative and has always allowed somebody just like me to attain their pursuits. Your own valuable information indicates so much a person like me and even more to my colleagues. With thanks; from all of us.

    回复 2019年10月24日
  3. nike react

    I would like to show my appreciation to the writer just for bailing me out of such a trouble. Just after exploring through the world-wide-web and seeing suggestions which were not helpful, I thought my entire life was over. Existing without the answers to the issues you’ve sorted out by means of the guide is a critical case, and the kind that might have in a wrong way affected my career if I had not come across your blog. Your mastery and kindness in playing with every part was tremendous. I’m not sure what I would’ve done if I had not come across such a thing like this. It’s possible to at this moment relish my future. Thanks for your time so much for the skilled and results-oriented guide. I will not be reluctant to recommend your web blog to anybody who wants and needs guidelines about this situation.

    回复 2019年10月24日
  4. jordan 12

    Thanks so much for providing individuals with remarkably spectacular possiblity to read critical reviews from this blog. It is always very cool and also full of fun for me and my office friends to search your website at the very least three times in a week to learn the new stuff you have got. Of course, I am always fascinated with the cool information you serve. Some 1 points in this posting are unquestionably the very best we’ve had.

    回复 2019年10月23日
  5. moncler

    I would like to get across my affection for your kindness for all those that need assistance with your situation. Your personal commitment to getting the solution throughout came to be astonishingly significant and has usually allowed girls like me to attain their aims. Your personal invaluable guide implies a great deal to me and further more to my office workers. Thanks a ton; from everyone of us.

    回复 2019年10月23日
  6. jordan shoes

    I and my buddies have been checking the best tips from your web site then before long I got a horrible feeling I never thanked you for those strategies. Most of the young men came as a consequence passionate to read them and now have seriously been loving them. Thank you for truly being indeed considerate as well as for obtaining varieties of helpful subject areas most people are really desperate to discover. My personal sincere apologies for not saying thanks to earlier.

    回复 2019年10月22日
  7. off white shoes

    I am just commenting to let you be aware of of the great experience my wife’s princess enjoyed reading through your site. She noticed plenty of pieces, including what it’s like to possess an amazing giving spirit to get many others without difficulty understand selected complicated subject areas. You really surpassed visitors’ expected results. I appreciate you for churning out such helpful, healthy, educational and also unique thoughts on this topic to Emily.

    回复 2019年10月21日
  8. louboutin

    I as well as my friends appeared to be reading the best hints found on your website while unexpectedly developed a terrible feeling I had not thanked you for those secrets. These people came certainly thrilled to study them and now have quite simply been tapping into them. I appreciate you for being simply helpful and then for getting some wonderful subjects most people are really desperate to learn about. Our honest regret for not saying thanks to earlier.

    回复 2019年10月20日
  9. yeezy boost 350 v2

    I would like to show my passion for your generosity in support of those people who must have guidance on your question. Your very own commitment to passing the message along had become really advantageous and have specifically helped ladies just like me to arrive at their aims. Your valuable advice can mean this much a person like me and far more to my office colleagues. Regards; from all of us.

    回复 2019年10月19日
    • cbd oil

      Excellent blog here! Also your site loads up very fast!

      What host are you the use of? Can I am getting your affiliate link
      on your host? I want my web site loaded up as quickly as yours lol

      回复 2020年3月15日
  10. hermes belt

    I wanted to write a quick word so as to say thanks to you for the pleasant advice you are writing on this website. My particularly long internet search has finally been paid with really good strategies to go over with my great friends. I ‘d tell you that most of us visitors actually are truly fortunate to dwell in a wonderful website with very many awesome people with great tactics. I feel truly fortunate to have used the web pages and look forward to really more cool minutes reading here. Thank you once more for everything.

    回复 2019年10月18日
  11. balenciaga sneakers

    I needed to send you that little note to help thank you so much over again relating to the superb opinions you’ve contributed above. This is simply surprisingly generous of people like you to provide unreservedly all many people could possibly have marketed as an electronic book in order to make some bucks for their own end, most notably now that you could possibly have tried it if you wanted. Those things in addition worked to be the great way to comprehend other people have similar zeal really like my personal own to find out more and more when considering this issue. I am sure there are some more enjoyable periods in the future for people who see your blog.

    回复 2019年10月17日
  12. valentino

    I wish to get across my admiration for your generosity giving support to persons that need assistance with this important topic. Your real dedication to getting the solution across became extremely productive and have continuously helped associates just like me to realize their goals. Your new informative tips and hints indicates a great deal to me and substantially more to my office workers. With thanks; from each one of us.

    回复 2019年10月17日
  13. kyrie 5 shoes

    I must voice my gratitude for your kindness in support of individuals who should have help with the matter. Your special commitment to getting the message around turned out to be extraordinarily significant and have specifically permitted guys just like me to attain their dreams. Your amazing interesting hints and tips denotes a whole lot to me and further more to my peers. Thanks a ton; from each one of us.

    回复 2019年10月16日
  14. air jordan

    I wanted to develop a brief comment in order to express gratitude to you for all the awesome secrets you are showing here. My rather long internet investigation has at the end of the day been honored with incredibly good information to talk about with my pals. I ‘d claim that many of us site visitors actually are rather blessed to live in a notable website with very many perfect individuals with very beneficial secrets. I feel really privileged to have encountered your entire website page and look forward to some more excellent minutes reading here. Thank you once more for everything.

    回复 2019年10月15日
  15. fila disruptor 2

    I as well as my guys were going through the best guides found on your site and then unexpectedly I got an awful suspicion I never expressed respect to the web blog owner for those tips. My ladies are actually for that reason warmed to read through all of them and have now actually been having fun with these things. Appreciate your turning out to be quite considerate as well as for making a decision on varieties of remarkable subject matter most people are really needing to be informed on. My honest regret for not expressing appreciation to earlier.

    回复 2019年10月14日
  16. StevDede

    Proscar Cabello Propecia Worldwide Cheap Bentyl Buying Medication Free Shipping Cialis generika rezeptfrei kaufen cialis Avana Pills Comprar Cialis En Murcia Levitra Generique Ligne

    回复 2019年10月13日
  17. christian louboutin shoes

    I would like to show thanks to you for bailing me out of such a difficulty. Right after scouting through the world-wide-web and getting techniques which were not productive, I believed my entire life was over. Existing minus the answers to the problems you have resolved by way of the article content is a serious case, as well as the ones which may have in a negative way affected my entire career if I hadn’t encountered the website. Your good training and kindness in controlling all the stuff was important. I don’t know what I would have done if I hadn’t come across such a solution like this. I am able to at this time relish my future. Thanks for your time very much for the impressive and effective help. I won’t hesitate to suggest your web page to any person who needs and wants direction on this situation.

    回复 2019年10月13日
  18. yeezys

    Thank you for your whole efforts on this web site. My mother take interest in participating in investigation and it’s really easy to understand why. Most of us notice all of the powerful manner you give valuable solutions via your web site and in addition cause response from visitors on this issue while our girl is really studying so much. Take pleasure in the rest of the new year. You have been conducting a really great job.

    回复 2019年10月12日
  19. moncler outlet

    I simply needed to appreciate you again. I’m not certain the things that I could possibly have achieved in the absence of these solutions contributed by you directly on this area of interest. Completely was a frustrating problem for me personally, however , viewing this expert manner you dealt with that forced me to leap over gladness. Now i am grateful for this assistance and as well , hope you really know what a great job you have been undertaking educating the rest through the use of your webblog. I’m certain you’ve never encountered any of us.

    回复 2019年10月11日
  20. yeezy boost 350 v2

    I needed to write you the very small observation to help give many thanks over again just for the pleasant tactics you have discussed on this page. This has been simply wonderfully generous of you giving freely all a few individuals could possibly have distributed as an e-book to get some bucks for their own end, principally considering that you might well have done it in case you considered necessary. Those inspiring ideas also worked as the easy way to fully grasp that other individuals have similar zeal much like my own to realize way more in regard to this problem. I know there are a lot more pleasant moments ahead for those who view your site.

    回复 2019年10月10日
  21. jordan shoes

    A lot of thanks for your own labor on this blog. Gloria delights in setting aside time for investigations and it is easy to see why. We all learn all regarding the lively tactic you provide good tricks through your blog and strongly encourage contribution from website visitors on that issue then our favorite girl is truly becoming educated a lot. Enjoy the rest of the new year. Your carrying out a fabulous job.

    回复 2019年10月9日
  22. yeezy

    I intended to put you that tiny note to finally give many thanks as before relating to the stunning secrets you’ve discussed on this site. It has been quite strangely generous with you to present without restraint all that a few individuals would have marketed as an e book to make some profit for their own end, and in particular since you could possibly have tried it in the event you considered necessary. These points likewise worked to become easy way to realize that someone else have a similar passion like my own to grasp significantly more regarding this condition. I know there are millions of more pleasurable times in the future for people who see your blog.

    回复 2019年10月8日
  23. longchamp handbags

    I wish to express some thanks to this writer for bailing me out of this type of predicament. As a result of checking through the search engines and coming across solutions which are not productive, I was thinking my life was done. Existing without the presence of strategies to the difficulties you’ve resolved through the review is a serious case, as well as those which might have badly damaged my entire career if I hadn’t encountered your website. Your primary natural talent and kindness in touching a lot of stuff was precious. I am not sure what I would have done if I hadn’t discovered such a subject like this. I can also at this moment look ahead to my future. Thanks a lot very much for the impressive and results-oriented guide. I won’t hesitate to endorse your web blog to any person who ought to have care about this issue.

    回复 2019年10月8日