Excel链接mysql数据库

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

发表评论



 


已有 1017 条评论 1


  1. Soccerstreams

    Hey there, You’ve done an incredible job. I will definitely digg it and personally suggest to my friends. I’m sure they’ll be benefited from this website.

    回复 2020年2月26日
  2. tension control bolts

    Do you mind if I quote a few of your posts as long as I provide credit and sources back to your site? My website is in the very same area of interest as yours and my visitors would certainly benefit from a lot of the information you present here. Please let me know if this alright with you. Thanks a lot!

    回复 2020年2月26日
  3. modern world construction

    Greetings! I know this is somewhat off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!

    回复 2020年2月25日
  4. Evacycle 回复 2020年2月25日
  5. Kiacycle 回复 2020年2月25日
  6. curry 6

    I wanted to create you one very little remark in order to thank you very much yet again for the great guidelines you’ve shared here. It was simply particularly open-handed of you to deliver easily precisely what a number of us could have marketed as an electronic book to make some dough for themselves, most notably seeing that you might have tried it in the event you considered necessary. The guidelines as well worked to become a good way to know that some people have similar zeal just as my personal own to grasp whole lot more with reference to this problem. I am sure there are millions of more fun times up front for many who scan through your blog post.

    回复 2020年2月25日
  7. Jodhpur escorts service

    Thank you for sharing excellent informations. Your site is so cool. I am impressed by the details that you have on this site. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found just the info I already searched all over the place and simply could not come across. What a great website.

    回复 2020年2月25日
  8. buy weed in uk

    I got what you mean , regards for putting up.Woh I am glad to find this website through google. “It is a very hard undertaking to seek to please everybody.” by Publilius Syrus.

    回复 2020年2月25日
  9. CBD

    Hey there! I just want to offer you a huge thumbs up for the excellent information you have got right here on this post. I will be returning to your site for more soon.

    回复 2020年2月25日
  10. Protection Collaborates With Superb Maids

    I was curious if you ever thought of changing the structure of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?

    回复 2020年2月25日
  11. click here

    Way cool! Some extremely valid points! I appreciate you writing this article plus the rest of the website is extremely good.

    回复 2020年2月25日
  12. Adidas Yeezy 回复 2020年2月25日
  13. home cleaning las vegas

    Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

    回复 2020年2月25日
  14. Evacycle 回复 2020年2月24日
  15. rachel cusk on becoming a mother

    I’m not that much of a online reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your website to come back later. Cheers

    回复 2020年2月24日
  16. click here

    I truly love your blog.. Great colors & theme. Did you develop this website yourself? Please reply back as I’m planning to create my very own website and would like to find out where you got this from or just what the theme is named. Many thanks!

    回复 2020年2月24日
  17. Bed assembly service

    I’ve observed that in the world the present day, video games are definitely the latest craze with kids of all ages. Many times it may be extremely hard to drag your kids away from the games. If you want the very best of both worlds, there are several educational activities for kids. Thanks for your post.

    回复 2020年2月24日
  18. CBD

    The very next time I read a blog, I hope that it won’t disappoint me as much as this one. After all, I know it was my choice to read, however I actually thought you’d have something useful to say. All I hear is a bunch of crying about something you could fix if you were not too busy looking for attention.

    回复 2020年2月24日
  19. Evacycle 回复 2020年2月24日
  20. ftjgau

    npmfhi best non prescription viagra generic drug
    cost of viagra in canada cvs pharmacy cialis

    回复 2020年2月24日
  21. Yeezy 回复 2020年2月24日
  22. Human Race Shoes 回复 2020年2月23日
  23. mobil bahis giris adresi

    I think this is one of the most vital information for me. And i am glad reading your article. But wanna remark on few general things, The web site style is wonderful, the articles is really great : D. Good job, cheers

    回复 2020年2月23日
  24. betgram

    Today, while I was at work, my cousin stole my iphone and tested to see if it can survive a 40 foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is completely off topic but I had to share it with someone!

    回复 2020年2月23日
  25. https://cashdomino88.com/

    I keep listening to the rumor speak about receiving boundless online grant applications so I have been looking around for the finest site to get one. Could you tell me please, where could i find some?

    回复 2020年2月23日
  26. page de renvoie internet

    I was suggested this web site by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my difficulty. You are incredible! Thanks!

    回复 2020年2月23日
  27. air jordans

    I in addition to my friends were actually looking at the nice items found on your web page and so at once got a terrible feeling I never expressed respect to the web blog owner for those tips. The men happened to be consequently warmed to see all of them and have in actuality been taking advantage of them. I appreciate you for indeed being quite helpful and for finding this kind of essential issues millions of individuals are really wanting to discover. Our sincere apologies for not expressing gratitude to earlier.

    回复 2020年2月23日
  28. Yeezy 回复 2020年2月23日
  29. gift basket and flowers

    It’s hard to find experienced people in this particular topic, but you sound like you know what you’re talking about! Thanks

    回复 2020年2月23日
  30. Evacycle 回复 2020年2月23日
  31. CBD oil near me

    I’m not sure why but this weblog is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later on and see if the problem still exists.

    回复 2020年2月22日
  32. Evacycle 回复 2020年2月22日
  33. Silver spring Hair salon

    That is really fascinating, You are a very professional blogger. I have joined your feed and look forward to in search of extra of your fantastic post. Also, I’ve shared your website in my social networks!

    回复 2020年2月22日
  34. DC Movers

    I figured out more a new challenge on this losing weight issue. One particular issue is that good nutrition is tremendously vital while dieting. A tremendous reduction in bad foods, sugary foods, fried foods, sugary foods, pork, and white flour products may perhaps be necessary. Holding wastes unwanted organisms, and toxins may prevent desired goals for shedding fat. While specific drugs for the short term solve the matter, the awful side effects are usually not worth it, they usually never give more than a short-term solution. It’s a known fact that 95% of diet plans fail. Many thanks sharing your thinking on this web site.

    回复 2020年2月22日
  35. Evacycle 回复 2020年2月22日
  36. Buy Phone Battery Online

    Thanks for your ideas. One thing I’ve got noticed is the fact banks in addition to financial institutions know the spending practices of consumers and as well understand that most people max out there their credit cards around the vacations. They wisely take advantage of this particular fact and begin flooding ones inbox and snail-mail box along with hundreds of no interest APR card offers just after the holiday season comes to an end. Knowing that if you’re like 98% of the American public, you’ll jump at the one opportunity to consolidate personal credit card debt and transfer balances to 0 rate credit cards.

    回复 2020年2月22日
  37. NFL Jerseys 回复 2020年2月21日
  38. DMV braiders

    Thank you for the sensible critique. Me and my neighbor were just preparing to do a little research about this. We got a grab a book from our area library but I think I learned more from this post. I’m very glad to see such excellent information being shared freely out there.

    回复 2020年2月21日
  39. Virginia Furniture installers

    Hi! I’ve been reading your site for a while now and finally got the courage to go ahead and give you a shout out from Atascocita Texas! Just wanted to say keep up the good job!

    回复 2020年2月21日
  40. DC office movers

    Simply wanna admit that this is very beneficial , Thanks for taking your time to write this.

    回复 2020年2月21日
  41. Evacycle 回复 2020年2月20日
  42. dotafrog

    As I web-site possessor I believe the content matter here is rattling excellent , appreciate it for your hard work. You should keep it up forever! Best of luck.

    回复 2020年2月20日