Excel链接mysql数据库

福尔摩斯对我笑 2019-01-03 23078 次 3540条
  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
未来博客 博主大人
到了这个年纪,不应该再彷徨!

air jordan进行回复 Cancel Reply



 


已有 3540 条评论 1


  1. 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日
  2. 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日
  3. 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日
  4. 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日
  5. 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日
  6. 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日
  7. 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日
  8. 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日
  9. 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日
  10. 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日
  11. 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日
  12. 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日
  13. 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日
  14. 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日
  15. 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日
  16. 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日
  17. 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日