Excel链接mysql数据库

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

louboutin进行回复 Cancel Reply



 


已有 4016 条评论 1


  1. bape hoodie

    I want to voice my passion for your kindness giving support to men and women that should have assistance with this field. Your special dedication to passing the solution up and down became particularly important and has consistently enabled girls like me to arrive at their aims. Your own valuable recommendations entails this much a person like me and further more to my fellow workers. Regards; from each one of us.

    回复 2019年10月30日
  2. supreme clothing

    Needed to send you the tiny word to help thank you very much yet again for all the unique advice you have provided on this site. This is quite surprisingly open-handed with you to present extensively just what a number of us could possibly have supplied for an e book to end up making some money on their own, and in particular seeing that you could have tried it if you ever considered necessary. Those secrets in addition served to be a easy way to be certain that other people have the identical dream just like mine to know more and more on the subject of this problem. I believe there are several more pleasurable sessions in the future for folks who go through your website.

    回复 2019年10月30日
  3. mbt shoes

    I wish to show thanks to the writer just for bailing me out of this particular incident. Right after looking out throughout the online world and meeting recommendations which were not helpful, I thought my life was done. Existing minus the solutions to the issues you have solved all through your good article content is a crucial case, and the kind that could have badly affected my entire career if I hadn’t discovered your web site. The skills and kindness in controlling all the details was important. I don’t know what I would have done if I had not encountered such a subject like this. I can also at this time look ahead to my future. Thanks very much for your high quality and sensible guide. I will not be reluctant to endorse your blog post to any individual who will need guidance about this subject matter.

    回复 2019年10月29日
  4. jordan shoes

    I in addition to my guys have already been examining the excellent suggestions on the blog then at once came up with an awful suspicion I never thanked you for them. My guys came certainly stimulated to read all of them and have in effect definitely been taking advantage of those things. Thanks for being indeed considerate and for opting for these kinds of incredible subjects millions of individuals are really needing to be informed on. My sincere regret for not expressing appreciation to sooner.

    回复 2019年10月29日
  5. off white hoodie

    I’m writing to let you understand of the superb experience my princess gained reading your site. She came to find some things, most notably what it is like to have an excellent coaching character to get men and women just gain knowledge of a number of multifaceted matters. You truly surpassed readers’ desires. Thanks for distributing these warm and friendly, healthy, edifying not to mention easy tips on the topic to Tanya.

    回复 2019年10月29日
  6. vans shoes

    I precisely had to thank you very much yet again. I am not sure what I would have taken care of in the absence of the type of creative ideas documented by you regarding that problem. This has been a real challenging dilemma in my opinion, but encountering a professional technique you resolved it forced me to weep with fulfillment. Extremely thankful for this help as well as trust you are aware of an amazing job you are doing teaching the rest by way of your websites. Most likely you haven’t got to know any of us.

    回复 2019年10月29日
  7. christian louboutin shoes

    I simply wanted to thank you so much once more. I do not know the things I could possibly have worked on without the tactics discussed by you regarding my topic. It was a real intimidating crisis in my opinion, nevertheless looking at the very skilled mode you resolved the issue forced me to cry for joy. Now i am happy for the information and as well , have high hopes you are aware of a great job you’re accomplishing training the mediocre ones all through your blog post. More than likely you haven’t come across any of us.

    回复 2019年10月28日
  8. yeezy boost 500

    Needed to send you the tiny remark to finally thank you very much yet again for those amazing guidelines you’ve featured above. It’s quite remarkably generous with you to give unreservedly exactly what a few people could have advertised for an e-book to make some bucks for themselves, especially now that you might have tried it if you desired. The good tips in addition worked as a good way to realize that many people have the identical interest like my very own to learn lots more in respect of this issue. I am certain there are thousands of more pleasurable times up front for individuals that read carefully your site.

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

    I precisely wanted to say thanks again. I do not know what I would have undertaken without these hints discussed by you relating to that field. It absolutely was an absolute troublesome difficulty in my view, but encountering the expert technique you treated that made me to jump over joy. Now i’m grateful for the help and then trust you recognize what an amazing job you are getting into teaching men and women via your website. I am sure you have never encountered all of us.

    回复 2019年10月27日
  10. yeezy shoes

    I want to show my respect for your generosity in support of those individuals that should have assistance with the situation. Your personal dedication to passing the message all through was extraordinarily useful and have constantly allowed associates just like me to achieve their ambitions. Your new helpful advice means a lot a person like me and much more to my office colleagues. Regards; from each one of us.

    回复 2019年10月27日
  11. ultra boost

    I am commenting to make you understand what a useful discovery my cousin’s princess found browsing the blog. She came to understand several details, most notably how it is like to have an excellent giving character to get the rest effortlessly gain knowledge of specified hard to do subject areas. You truly exceeded people’s expected results. Many thanks for presenting such practical, safe, informative and as well as fun guidance on that topic to Mary.

    回复 2019年10月27日
  12. cheap jordans

    I needed to put you a very small note in order to say thank you the moment again on the breathtaking thoughts you have contributed on this page. It has been simply incredibly open-handed with people like you to present unreservedly what many people might have distributed as an e book to earn some money for themselves, principally given that you could possibly have tried it if you decided. Those pointers likewise acted like the good way to know that other people have the identical dreams really like my own to see many more related to this problem. Certainly there are thousands of more pleasant periods in the future for folks who take a look at your blog post.

    回复 2019年10月27日
  13. golden goose outlet

    Thanks for all of the work on this blog. Betty delights in managing research and it is simple to grasp why. We all know all regarding the lively means you offer invaluable tactics by means of the web blog and therefore attract response from others on that situation while our favorite daughter is undoubtedly being taught a great deal. Have fun with the remaining portion of the new year. You have been doing a superb job.

    回复 2019年10月26日
  14. off white

    I wanted to draft you a very little remark so as to say thanks a lot the moment again for all the breathtaking techniques you have documented on this site. This is so seriously open-handed with you to offer unreservedly precisely what most of us could possibly have advertised as an e-book to earn some dough for themselves, specifically seeing that you might have tried it if you ever wanted. Those things likewise served to be the great way to be aware that other individuals have a similar eagerness just like mine to know the truth a little more with respect to this problem. Certainly there are some more pleasurable situations ahead for many who see your blog post.

    回复 2019年10月26日
  15. moncler coats

    I must show some appreciation to this writer for bailing me out of this challenge. Because of exploring through the world wide web and finding strategies which were not productive, I believed my life was over. Being alive minus the solutions to the problems you have resolved all through your entire guide is a serious case, as well as the ones that could have in a wrong way affected my career if I hadn’t discovered your blog. Your personal training and kindness in taking care of all areas was tremendous. I don’t know what I would’ve done if I had not discovered such a step like this. I’m able to at this time look forward to my future. Thank you so much for the reliable and results-oriented help. I won’t hesitate to refer the website to any individual who would like support about this matter.

    回复 2019年10月26日
  16. adidas tubular

    I’m also commenting to let you be aware of of the magnificent experience my cousin’s daughter enjoyed studying your site. She came to find a wide variety of pieces, not to mention how it is like to have a very effective teaching mindset to get a number of people without difficulty comprehend various tortuous things. You undoubtedly did more than our own expectations. Thank you for coming up with such interesting, healthy, informative and in addition unique guidance on that topic to Lizeth.

    回复 2019年10月26日
  17. nike air max 97

    My wife and i felt satisfied that Ervin could do his researching through the precious recommendations he was given while using the site. It is now and again perplexing just to continually be offering strategies that many some others have been selling. We really realize we have got the writer to give thanks to because of that. The most important explanations you have made, the easy web site navigation, the friendships you will aid to create – it is everything impressive, and it is making our son and us consider that this concept is amusing, which is certainly unbelievably fundamental. Many thanks for the whole thing!

    回复 2019年10月25日
  18. nmd

    Thanks so much for providing individuals with an extraordinarily superb chance to read critical reviews from this website. It really is very cool plus jam-packed with a great time for me personally and my office mates to visit your web site at a minimum thrice per week to see the newest things you have. Not to mention, I am also usually impressed with all the attractive principles you give. Certain two areas in this article are really the most suitable we have had.

    回复 2019年10月25日
  19. golden goose sneakers

    I wish to show my appreciation to you just for bailing me out of such a condition. Right after searching throughout the internet and getting recommendations which were not pleasant, I was thinking my life was done. Existing without the approaches to the issues you have fixed through your guideline is a crucial case, and ones that would have negatively affected my entire career if I hadn’t encountered your site. Your own personal natural talent and kindness in dealing with every aspect was vital. I don’t know what I would’ve done if I hadn’t come upon such a subject like this. I am able to at this point look forward to my future. Thanks for your time so much for your reliable and results-oriented help. I won’t hesitate to propose your site to any person who desires counselling on this situation.

    回复 2019年10月25日
  20. birkin bag

    I’m just commenting to let you know of the impressive experience my wife’s daughter gained checking your web site. She figured out numerous things, which included what it’s like to possess an awesome giving style to have the mediocre ones really easily learn some extremely tough things. You actually surpassed her expected results. Many thanks for providing such informative, healthy, explanatory and even easy tips on your topic to Janet.

    回复 2019年10月24日
  21. 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日
  22. 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日
  23. 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日
  24. 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日
  25. 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日
  26. 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日
  27. 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日
  28. 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日
  29. 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日
  30. 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日
  31. 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日
  32. 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日
  33. 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日
  34. 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日
  35. 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日
  36. 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日
  37. 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日
  38. 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日
  39. 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日
  40. 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日
  41. 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日
  42. 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日
  43. 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日