Softwares

Connecting Excel 2007 to MySQL Database

There are times that you need to analyze your data from your MySQL database, you can either connect from your database admin and export your data as CSV or you can do it directly by connecting Microsoft Excel to your MySQL database to query or fetch your data. To do this you need the to install and configure the ODBC (Open Database Connectivity) connector database driver. You can get it from here: MySQL-Connector-ODBC-5.1.5-win32.msi
Once you completed your download install the ODBC connector, once installed go to Control Panel > Administrative Tools > Data Sources (ODBC) >Add > Select MySQL ODBC 3.51 driver. and click finish.


After clicking finish configure your database connection by supplying the parameters being asked for:


Click test, to test your connection to see if you can successfully connect to your database instance. In Microsoft Excel 2007 click on your Data Menu > From Other Sources > From Data Connection Wizard > ODBC DSN then next. Notice that after clicking the next button you can see the database connection name that you created in the administrative tools.

Select it and the table that you like to import in excel on the dialog box click ok: After successful import you will see your data on the excel tables.

Note: This configuration is almost the same with Microsoft Excel 2003.

Listen to this post