Excel链接mysql数据库

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

kd 10进行回复 Cancel Reply



 


已有 2758 条评论 1


  1. 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日
  2. 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日
  3. 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日
  4. 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日
  5. 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日
  6. 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日
  7. 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日