How to use SSMA for Access on O365 ProPlus? RRS feed

  • Question

  • In the latest version of Access for O365 ProPlus there is no SQL Upsizing Wizard tool. I have read that this method was deprecated in favor of Microsoft SQL Server Migration Assistant (SSMA). I am here to report that it is impossible to install this tool when running the latest version of O365 ProPlus.

    When the installer for SSMA is run it complains that it cannot find the DAO libraries that it needs, despite Access being installed. There is a download button there to save you! That links you to the Access Runtime for 2016. Unfortunately, the Access Runtime installer clearly states that it won't run because O365 ProPlus is installed. Full bork.

    Is there a way I can continue to use SSMA for Access in the future?

    Is there a different tool I should be using for exporting Access tables to SQL?

    I captured the whole debacle in one screenshot:

    SSMA need DAO, DAO can't install


    OS: Windows 10 Pro 1909 18363.535 64-bit
    OFFICE: O365 ProPlus Version 1902 64-bit
    ACCESS: 16.0.11328.20492 64-bit

    Thursday, December 19, 2019 6:40 PM


All replies