Converting Access Database to MSSQL Database Using Microsoft SQL Server Migration Assistant for Access

sql sql-server database ms-access ms-access-2010

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.

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.

sql sql-server database ms-access ms-access-2010

I remember this error. I had to find the EXE for 32-bit SSMA even though I was running 64-bit windows. The default installed location was:

C:\Microsoft SQL Server Migration Assistant for Access\bin

And the filename was:

SSMAforAccess32.exe

sql sql-server database ms-access ms-access-2010

[SOLVED]

I encountered the same error while using SSMA v7.7.0 for migrating from MS-Access 2016 DB to SQL Server 2017. Fortunately, I got it fixed by installing Microsoft Access Database Engine 2016 Redistributable

CodeHunter