Others

Fix Missing Access Tables in SQL Server Migration Assistant

Bushra ParveenBushra Parveen Nov 20, 2026 868 views

Question details

The user needs SQL Server Migration Assistant for Access to display the tables in an Access database.

Fix Missing Access Tables in SQL Server Migration Assistant
Product
SQL Server Migration Assistant for Access
Device & OS
not provided
Scenario
Migrating an Access database to SQL Server using SSMA for Access with 64-bit Access Runtime installed.
Observed behavior
SSMA for Access does not display the database tables.
Before you start

Locate the Access database file you intend to migrate and confirm that you can access it. Check whether its tables are stored in that file or linked to another database.

Solution 1Recommended

Check the Access source and refresh its metadata

Use this first to rule out an incorrect source file, missing tables, or insufficient access permissions.

1
Check the source file

In SSMA for Access, use the Add Databases command to select the intended .accdb or .mdb file. Confirm that the selected path points to the database containing the tables.

2
Expand the database

In Access Metadata Explorer, expand the added database and its Tables node to check whether the tables are listed.

3
Refresh the metadata

Right-click the source database in Access Metadata Explorer and select Refresh from Database, if available. Expand Tables again after the refresh completes.

4
Check access to the tables

Open the source file in Access, if available, and verify that it contains tables and that your account can read them. For linked tables, also check access to their underlying data sources.

Check the Access source and refresh its metadata
Free Microsoft Office alternative

Work with Exported Access Data in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with exported spreadsheet data and other Office files. Its format compatibility helps you move everyday documents between Office suites. It does not fix SSMA or migrate Access databases to SQL Server.

Review and edit Access data exported to a spreadsheetOpen and edit Microsoft Excel XLSX filesWork in a familiar, easy-to-use office interfaceUse a free, lightweight suite for everyday documents
microsoft office alternative - wps office

Frequently Asked Questions

Why does SSMA show my Access database but no tables?

The selected file may not contain the expected tables, your account may lack access, or SSMA may not be able to read the database through a compatible provider. Check the source path, expand Tables in Access Metadata Explorer, and refresh the database metadata.

Does installing 64-bit Access Runtime guarantee that SSMA will see my tables?

No. Access Runtime alone may not resolve the issue. Check that the Access Database Engine provider required by your SSMA version is installed and matches the SSMA process architecture.

What should I check if my Access tables are linked?

Open the source database in Access, if available, and inspect the linked tables. Confirm that the underlying data source is reachable and that your account has permission to read it.

Can WPS Office migrate an Access database to SQL Server?

No. Use a migration tool such as SSMA for that task. WPS Spreadsheets can work with data exported to a compatible spreadsheet format such as XLSX.