Mysql For Excel Install Process Is

Once the install process is complete you will need to create a Database Source Name (DSN) to use with Excel.

On a Windows system, you will need to click on Start, then Control Panel, then Administrative Tools, then Data Sources (ODBC).

You should see the following information: Incontent1 all:300x250dfp:640x360 --.

Mysql For Excel Driver Is Highlighted

To continue creating the DSN, make sure MySQL ODBC 5.x Driver is highlighted and click on the Finish button.

You should now see a window similar to the one listed below.

The MySQL database and table were using for this post is on a development machine and is only used by one person.

For production environments, it is suggested you create a new user and grant the new user SELECT privileges only.

In the future, you can grant additional privileges if necessary.

You should now see the data source name you supplied on the form in the previous set listed on the ODBC Data Source Administrator window.

For newer versions of Excel, click on Get Data, then From Other Sources, then From ODBC.

The location of the Connections link is circled in red in the above image.

You should be presented with the Workbook Connections window.

Therefore, you want to double click on the Connect to New Data Source.odc folder.

In doing so, you should be now see the Data Connection Wizard window.

The next step of the Data Connection Wizard will display all of the ODBC data sources available on the system you are using.

The description used in the example is pretty self explanatory for anyone that might use it.

Next, click on the Finish button in the lower right of the window.

The Existing Connections button should be located to the left on the Data ribbon.

Youve seen this window in previous steps, the difference now is that your data connection should be listed near the top.

If everything worked out for you, you should now be presented with the MySQL database table data in your worksheet.

You can also use the drop down arrows next to the column names to sort the columns.