Home>

https: //blog.mori-soft .com/entry/2016/11/11/172234

I want to migrate Access tables to SQLServer as in the above site.

Error message

https://social.msdn.microsoft.com/Forums/en-US/02efe6f4-326a-40a8-991e-abf825528ccc/sql-server-migration-assistant -for-access-v75012395123881235612390? forum = sqlazureja

Similar to the above site, existing tables are not displayed when selecting tables.

Therefore, the error message "There is nothing to process" will be displayed.

In the above site, it seems that it was solved by aligning the number of bits of SSMA and Access,

I confirmed that both SSMA and Access were 64-bit.

If i have a solution, please let me know.

  • Answer # 1

    Installing SQL Server Migration Assistant for Access (AccessToSQL)
    https://docs.microsoft.com/en-us/sql/ssma/access/installing-sql-server-migration-assistant-for-access-accesstosql?view=sql-server-ver15

    According to Microsoft Data Access Object (DAO) provider version 12.0 or 14.0.

    That means Microsoft Access 2007 or 2010 is required.

    "Microsoft Access 2010 Runtime"
    https://www.microsoft.com/en-us/download/details.aspx?id=10910

    You can download AccessRuntime.exe and AccessRuntime_X64.exe from

    .