Fix Power Pivot Import of Linked Access Tables in Excel
Question details
Import data from Access tables linked to Excel workbooks into the Excel Data Model.

- Product
- Microsoft Excel Power Pivot and Power Query
- Device & OS
- not provided
- Scenario
- An Access database contains tables linked to Excel workbooks, and the user wants to use their data in Power Pivot.
- Observed behavior
- Power Pivot may report that no tables were found when importing the linked tables, even though local Access tables can be imported.
Identify the Excel workbooks behind the linked Access tables and make sure you can open them. In Access, check the linked table properties or Linked Table Manager to locate their source files.
Import the source Excel workbooks through Power Query
Use this workaround when Power Pivot cannot find Access tables linked to Excel files.
Connecting to the source workbooks bypasses the linked tables in Access. Recreate any needed Access transformations or relationships in Power Query or the Data Model.
In Excel, select Data > Get Data > From File > From Workbook, then browse to an Excel file used by a linked Access table.
In Navigator, select the relevant sheet or table, then choose Transform Data to open Power Query Editor.
Use the Power Query Editor commands to clean the data. If you have multiple source files, add queries for them and use Append Queries or Merge Queries as needed.
Select Home > Close & Load > Close & Load To. Choose Only Create Connection, select Add this data to the Data Model, and click OK.
Open Power Pivot > Manage to verify that the imported data appears, and create relationships between tables if needed.

Work with Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to review and edit source data with an easy transition from Microsoft Office. It does not fix Power Pivot or replace this Power Query workflow.

Frequently Asked Questions
Why does Power Pivot show no tables in my Access database?
Power Pivot may not recognize Access tables that are linked to Excel workbooks, even when local Access tables are available. Connect to the underlying workbooks through Excel's Data > Get Data menu instead.
How do I load a Power Query result into Power Pivot?
In Power Query Editor, select Home > Close & Load > Close & Load To, then select Add this data to the Data Model. You can check the result under Power Pivot > Manage.
Can I combine data from several linked Excel workbooks?
Yes. Create a Power Query connection for each source workbook, then use Append Queries to stack similar data or Merge Queries to join matching rows.
Will the query update when a source workbook changes?
You can refresh the imported data using Data > Refresh All, provided the source files remain accessible. If a file has moved, update the query's source path first.
Does importing the source workbooks preserve my Access relationships?
Not automatically. After loading the data, check Power Pivot > Manage and recreate any relationships needed in the Data Model.




