Data Import & Export

Fix a Missing MySQL ODBC Data Source in Excel 2016

John WilsonJohn Wilson Nov 20, 2026 868 views

Question details

The user needs a MySQL ODBC data source to appear in Microsoft Query in Excel 2016.

Fix a Missing MySQL ODBC Data Source 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.
Before you start

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.

Solution 1Recommended

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'.

1
Check Excel's architecture

In Excel, select File > Account > About Excel and check whether the version is 32-bit or 64-bit.

2
Open the matching administrator

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.

3
Check the MySQL driver

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.

4
Create or check the DSN

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.

5
Restart Excel and select the source

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.

Match the MySQL ODBC driver and data source to Excel's architecture
User and system data sources: A User DSN is available to the Windows user who created it. Use a System DSN when the data source needs to be available to other users on the computer.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface to ease migration from ExcelReview and analyze data already saved in a spreadsheetWork with a free, lightweight office suite
microsoft office alternative - wps office

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.