Data Import & Export

How to Fix Excel Not Retrieving Data from an Access Database

Rana GarciaRana Garcia Nov 3, 2026 869 views

Question details

The user is unable to retrieve data from specific Microsoft Access tables into Excel, despite other tables connecting successfully.

How to Fix Excel Not Retrieving Data from an Access Database
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.
Before you start

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.

Solution 1Recommended

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.

1
Test data in Access

Open the target database directly in Microsoft Access to confirm the specific table or query opens without errors and contains the latest data.

2
Delete existing connection

In Excel, go to the 'Data' tab, click 'Queries & Connections', find the problematic connection in the side panel, right-click it, and select 'Delete'.

3
Establish a new connection

Still on the 'Data' tab, click 'Get Data' (or 'New Query' in older versions), select 'From Database', and then choose 'From Microsoft Access Database'.

4
Select the correct table

Browse to the current location of your database file, select the exact table or query you need from the Navigator window, and click 'Load'.

Verify and Recreate the Database Connection
Connection Preferences: When setting up the new connection, it is generally recommended to select the Access tables directly rather than relying on older Microsoft Office Data Connection (ODC) files.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the quick installation wizard to get WPS Office running in minutes.
  3. 3. Open your data files: Launch WPS Spreadsheet and open your existing data files directly, with all your formats and basic functions retained flawlessly.
Fully compatible with Microsoft Excel file formats (.xls, .xlsx, .csv).Easily import data from text files, CSVs, and web sources without complex driver configurations.Lightweight installation with fast startup and reliable performance.Free to use with a familiar, tabbed user interface for seamless migration.
QA img-9

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.