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

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

Advertisements

About jasontarby

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

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

  1. Pingback: SQL Server Migration Assistant for Access nightmare – Explosive Insight

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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