Issue:
On a Windows 64bit system running Microsoft Office 2010 64bit, when you attempt to migrate an Microsoft Access database to Microsoft SQL Server using the SSMA, you receive the following error:
Retrieving the COM class factory for component with CLSID {16AA0B9E-79AC-43B5-86CA-AB961FBEED5F} failed due to the following error: 80040154.
Resolution:
You can easily resolve this issue by installing the 2007 Office System Driver: Data Connectivity Components. You can download it from this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
Pingback: SQL Server Migration Assistant for Access nightmare – Explosive Insight