Microsoft SQL Server Migration Assistant for Access Issue on 64bit Systems


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.


You can easily resolve this issue by installing the 2007 Office System Driver: Data Connectivity Components.  You can download it from this link:


About jasontarby

Enterprise Architect / Network Engineer at SRA International, Inc.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s