Either the Unicode or ANSI driver should work, but if you require Unicode support ensure you use the Unicode variant. Then, select the MySQL driver and click Finish to move the next step of adding the MySQL server details. To add as a User DSN, go to the User DSN tab and click Add… You can add the new data source as either a System DSN or User DSN, with the former meaning it will be accessible to all users on the system and the latter being accessible only to the current user. ODBC Data Source Administrator showing driver installation. You should now see the driver listed under the Drivers tab. If you are given the option of opening the 32-bit or 64-bit window, open the one that matches the driver you installed and your Excel install. Open the ODBC Data Sources Administrator by searching for it in the start menu. With MySQL Connector/ODBC installed, you need to configure the data source in Windows so we can use it in Excel. About Excel showing 32-bit install Step 2: Setup the MySQL Server as an ODBC Data Source
You can check your Excel install by going to File > Account and clicking About Excel. In my case, I have a 64-bit system but 32-bit Excel so I actually needed the 32-bit driver.
It is important to match the architecture of the driver with the architecture of your Excel install. This is the ODBC driver that will allow you to add a MySQL server as a data source. Step 1: Install MySQL Connector/ODBCįirstly, you must install the MySQL Connector/ODBC software. This tutorial should work on Microsoft Excel 2016 or greater with Microsoft Windows. If you are looking to do the reverse and import an Excel table into any SQL database (including MySQL), try my other tutorial here.
In this article, you will learn how to import a MySQL Table from the database into an Excel table using an ODBC Database Query.