Fix Missing Access Tables in SQL Server Migration Assistant
Question details
The user needs SQL Server Migration Assistant for Access to display the tables in an Access database.

- 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.
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.
Check the Access source and refresh its metadata
Use this first to rule out an incorrect source file, missing tables, or insufficient access permissions.
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.
In Access Metadata Explorer, expand the added database and its Tables node to check whether the tables are listed.
Right-click the source database in Access Metadata Explorer and select Refresh from Database, if available. Expand Tables again after the refresh completes.
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.

Verify the Access provider and SSMA architecture
Use this when the correct database is selected but SSMA still cannot read its tables.
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.

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.




