EG-DesignStudio | Connecting Microsoft Excel 2007 to MySQL Database

Search

// archives

Connecting Microsoft Excel 2007 to MySQL Database

This tag is associated with 1 posts

Connecting Excel 2007 to MySQL Database

By xeroxss ⋅ November 14, 2008 ⋅ Post a comment

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:

Register and Participate

Registration to this website is free. Feel free to use and explore the features of the website. You are welcome to participate and interact with us in the forum. If you have concerns that you want us to know you can easily contact us using this link. By registering in this website, your account will allow you to login and participate in the forum and to access additional information that is only available to registered users. We are keeping this website to be informative for us and to our users.