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!