Converting Access Database to MSSQL Database Using Microsoft SQL Server Migration Assistant for Access
Just to complete the other side of the story...
If you have a 64-bit setup, you might have to go the other direction
and install the 64-bit MSAccess 2010 engine.
I'm running Access 2013, and I believe it is 64-bit.But the SMAA tool threw the 80040154 error.
- I think SMAA can't or doesn't use the 64-bit connectivity drivers that come with 64-bit Access 2013.
So using the 32-bit SMAA didn't help.
- Installing the 64-bit 2010 engine did.
I got it as a free standalone download here:
After the quick install of this, I simply started
SMAA 64-bit again,
and the wizard was successful the first time.
thanks to :https://social.technet.microsoft.com/Forums/itmanagement/en-US/0249eebf-14bd-45f6-9bca-3b42395a3d13/ssma-60-error-retrieving-the-com-class-factory-for-component-failed-due-to-the-following-error?forum=sqlservermigration