Connect to a MySQL Database From Excel 2007 and Import the Database into Excel - STEP BY STEP

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Connect to a MySQL database with Excel 2007 and import that database into Excel. This Excel video tutorial is a step-by-step walk-through of everything you need to do to import MySQL database tables and columns into Excel. This includes showing you how to download and install the necessary ODBC drivers for Excel.

You will learn what file you need to download from MySQL in order to access the database through Excel and then how to install that file; after that, you will learn exactly how to setup a new web query from Excel 2007 and how to enter all of your database information into Excel. From there you will learn how to import a table or individual columns from that database into Excel.

This is a comprehensive example of how to import data from a MySQL database directly into Excel without copy pasting data and without going through an interface like PHPMyAdmin. In this tutorial you will learn how to directly connect to the MySQL database from Excel 2007.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• connect
• mysql
• database
• excel
• import
• data
• tables
• columns
• query
• new
• odbc

[mgladdens]

Great video. Is there a similar way to export the data from excel worksheet to MySQL database? 

[ExcelisHell]

@mgladdens Yes there is, especially if you use phpmyadmin. You can private message me about your specific situation or just search for it online.

[jsilvajetter]

Hi, This is a beginer's question, I think, but...

What do I put in the 'Server' field ... i mean the server name of course but what exactly is that? can you give an example? I have a shared hosting account, will I be able to access my database thru there or do I need a dedicated IP address?

[ExcelisHell]

@jsilvajetter I'll private message you the answer since you don't want too much info. about your website/db put onto the net.

[ExcelisHell]

Per user comments, note that some people say My S.Q.L. and some people say My 'sequel' and that is why I say it both ways in this tutorial. Nevertheless, I hope this tutorial has been helpful.

[LovelyLady301]

This video is absolutely awesome. You are very good at what you do. Thank you! One thing that would make things a little easier, is if there was a direct link in the "Show More" area, or if we could copy/paste the URL to download the MySQL ODBC Connector.

[otherwise777]

thnx good video helped me a bunch

[techguy1187]

AMEN!!! FINALLY SOMEONE KNOWS HOW TO EXPLAIN THIS!!!! I AM SO SUBBING!

[yanyue0]

thanks for help, man, its exactly what i need XD

[spidolino]

tnx man

[75whitehawk]

very helpful, thank you. I tried it with 2003. it's perfect. helped me set up mysql odbc connection for msaccess too. thanks a lot