Fix a Missing MySQL ODBC Data Source in Excel 2016
Question details
The user needs a MySQL ODBC data source to appear in Microsoft Query in Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- The user is importing MySQL data through an ODBC data source in Excel.
- Observed behavior
- The data source works in Windows ODBC Administrator but is not listed when the user opens Microsoft Query from Excel.
Make sure the MySQL ODBC driver is installed and note the name of the existing data source. Check whether you are using the same Windows account in Excel and ODBC Administrator.
Match the MySQL ODBC driver and data source to Excel's architecture
Use this solution when a working MySQL DSN is missing from the Microsoft Query data source list.
Excel and the MySQL ODBC driver must both be 32-bit or both be 64-bit. The relevant architecture is Excel's, not just Windows'.
In Excel, select File > Account > About Excel and check whether the version is 32-bit or 64-bit.
Open the Start menu, search for ODBC Data Sources, and select ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit) to match Excel.
In ODBC Data Source Administrator, open the Drivers tab and look for the MySQL ODBC driver. If it is missing, install the MySQL ODBC driver matching Excel's architecture.
Open the User DSN or System DSN tab and select Add to create the MySQL data source if it is not listed. Enter the connection settings and use the driver's test button, if available, to verify the connection.
Close and reopen Excel, then go to Data > Get Data > From Other Sources > From Microsoft Query and look for the DSN in the data source list.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with them in WPS Spreadsheets. It does not fix Excel's Microsoft Query or ODBC configuration.

Frequently Asked Questions
Why does my DSN appear in ODBC Administrator but not in Excel?
The DSN may have been created in an ODBC Administrator with a different architecture from Excel. Check File > Account > About Excel, then open the 32-bit or 64-bit ODBC Administrator that matches Excel and check its User DSN and System DSN tabs.
Do I need a 64-bit MySQL driver if Windows is 64-bit?
Not necessarily. The MySQL ODBC driver must match Excel's architecture. For example, 32-bit Excel needs a 32-bit driver even on 64-bit Windows.
What is the difference between a User DSN and a System DSN?
A User DSN is associated with the Windows user who created it, while a System DSN is available to other users on the computer. Create or check the appropriate entry in the matching ODBC Administrator.
What should I do after creating the DSN?
Restart Excel, then open Data > Get Data > From Other Sources > From Microsoft Query and check the data source list for the DSN.




