Error when migrating Access database to SQL Server

[AnneForumer]

Please let me know if this is not the right place to ask this question:



I am trying to migrate my .accdb to SQL Server 2014 Express using "SQL server Migration Assistant" (SSMA) but I get the following error:

Access Object Collector error: Database
Could not load file or assembly 'Microsoft.Office.Interop.Access.Dao, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
Error occurred while loading children.

I have Office 2013 installed on my machine. SSMA is version 7.1. I had an older version of SSMA installed but I got the exact same error. I do see that PIA under "Office 15" directory, but apparently that is not good enough.

I'd appreciate any help so I can get going.

Thank you!

[ranman256]

You don't need migration assist.
just do external tables, ODBC ,and add in the tables you need.

make sure you have the current ODBC driver for your db.