How to Fix Excel Not Retrieving Data from an Access Database
Question details
The user is unable to retrieve data from specific Microsoft Access tables into Excel, despite other tables connecting successfully.

- Product
- Microsoft Excel, Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to import or refresh data from a Microsoft Access database into an Excel spreadsheet over a network drive or local connection.
- Observed behavior
- Excel successfully connects to certain Access tables but fails to retrieve data from others due to potential connection, permission, or driver issues.
Ensure you have read and write permissions to the network folder hosting the Access database, and verify that the database is not currently locked in exclusive mode by another user.
Verify and Recreate the Database Connection
An outdated or corrupted data connection is a common cause for retrieval failures. Recreating it ensures Excel points to the correct, updated production database.
Sometimes Excel retains obsolete connection pathways, especially when files are moved on a network drive. Testing the table directly in Access before reconnecting ensures the source data is actually available.
Open the target database directly in Microsoft Access to confirm the specific table or query opens without errors and contains the latest data.
In Excel, go to the 'Data' tab, click 'Queries & Connections', find the problematic connection in the side panel, right-click it, and select 'Delete'.
Still on the 'Data' tab, click 'Get Data' (or 'New Query' in older versions), select 'From Database', and then choose 'From Microsoft Access Database'.
Browse to the current location of your database file, select the exact table or query you need from the Navigator window, and click 'Load'.

Check Data Types and Access Database Engine Drivers
Incompatible field types or architecture mismatches between Excel and the Access Database Engine can block data retrieval for specific tables.
Experience Hassle-Free Data Management with WPS Office
If you frequently encounter complex database connection errors and driver mismatches within the Microsoft ecosystem, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling robust spreadsheets and daily data tasks without the steep troubleshooting curve.
- 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the setup file and follow the quick installation wizard to get WPS Office running in minutes.
- 3. Open your data files: Launch WPS Spreadsheet and open your existing data files directly, with all your formats and basic functions retained flawlessly.

Frequently Asked Questions
Why does Excel link to one Access table but fail on another in the same database?
This usually happens when the failing table has restrictive permissions, contains incompatible complex data types, or relies on a background query that is broken within the Access database itself.
Are updates made in an Access database automatically reflected in Excel?
No, links between Access and Excel are typically one-way and not live. To see updates, you must manually go to the 'Data' tab in Excel and click 'Refresh All', or use VBA code to automate the refresh process.
Should I use Microsoft Office Data Connection (ODC) files or connect directly to the Access table?
It is generally more reliable to connect directly to the Access table or query using the 'Get Data' feature. ODC files on network drives can sometimes become outdated, corrupted, or point to legacy server paths.




