'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Cannot Connect Directly to SQL Server but ODBC Works
Question details
Users are unable to connect Excel directly to a SQL Server database using the Get Data feature, even though the connection works fine using an ODBC data source.
- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Importing database tables from SQL Server into a Microsoft Excel spreadsheet for data analysis.
- Observed behavior
- The direct SQL Server connection fails in Excel's Data > Get Data menu, but the same database can be accessed successfully through an ODBC configuration.
Ensure you have Windows administrator privileges on your computer to modify ODBC Data Source settings and verify your SQL Server login credentials.
Configure the ODBC Connection under System DSN
Switching the connection from a User DSN to a System DSN ensures the driver architecture and system-wide permissions allow Excel to recognize and authenticate the connection.
Excel often struggles to retrieve data from User DSNs due to permission isolation in newer Windows architectures. Moving the connection to a System DSN resolves this.
Press the Windows key, type 'ODBC Data Sources', and select the version (64-bit or 32-bit) that matches your Microsoft Excel installation architecture.
Click on the 'System DSN' tab at the top of the window instead of the default 'User DSN' tab.
Click the 'Add' button, select your SQL Server driver from the list, and click 'Finish'.
Enter a name for the connection, type in your SQL Server address, and proceed through the wizard to input your authentication credentials.
Click 'Test Data Source' to ensure the connection works, click 'OK' to save, and then restart Excel to try the Get Data function again.
Verify Driver and Excel Architecture Match
Mismatched bit architectures between your installed SQL Server driver and Microsoft Excel can prevent direct connections from establishing.
Repair Microsoft Office and Check Network Firewalls
If network settings and drivers are correct, repairing the Office installation and verifying firewall ports can resolve underlying software or connectivity blockages.
Experience Seamless Data Management with WPS Office
Struggling with complex Excel database connections and missing drivers? WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy a familiar interface and seamless file management without the heavy troubleshooting.
- 1. Download WPS Office: Visit the official WPS website and download the free version for your operating system.
- 2. Install the Software: Run the setup file and complete the quick, lightweight installation process.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing .xlsx files to continue working on your data.
Frequently Asked Questions
Why does my ODBC connection work but Excel's direct SQL connection fails?
Excel's direct 'Get Data' feature relies on different underlying data providers (such as the .NET Framework Data Provider for SQL Server) compared to a standard ODBC connection. If this specific provider is missing, outdated, or blocked by local permissions, the direct connection will fail even if standard ODBC traffic goes through.
What is the difference between a User DSN and a System DSN in ODBC?
A User DSN is only accessible by the specific Windows user profile that created it. A System DSN is accessible system-wide by any user or background service on that machine. Excel frequently requires a System DSN to properly authenticate and route database queries without permission conflicts.
How do I know if I am using 32-bit or 64-bit Excel?
Open Microsoft Excel, click on 'File', navigate to 'Account', and click 'About Excel'. The top line of the pop-up window will clearly specify whether you are running a 32-bit or 64-bit installation.
Which SQL Server driver should I use for Excel Microsoft 365?
It is highly recommended to use the latest Microsoft ODBC Driver for SQL Server (such as version 17 or 18) available from the official Microsoft download center. Make sure to download the specific bit-version (32-bit or 64-bit) that matches your Excel application, regardless of your Windows OS architecture.
