Cannot Export to Microsoft Excel on Windows x64-bit Platform

I am getting an error when trying to export to Excel: Could not create output .xls data source

  • Guest
  • Oct 22 2015
  • FAQ
Company
  • Oct 22, 2015

    Admin Response

    Export to Microsoft Excel requires the Microsoft Excel ODBC driver, which may not be installed on some x64 bit platforms
     
    To add x64-bit ODBC support please download and install the Microsoft Access Database Engine 2010 Redistributable (or search for "AccessDatabaseEngine_x64.exe")
     
    Alternatively, use the Edit->Copy Task(s) as Text to copy schedule information from Synchro to paste into MS-Excel; or Edit->Paste Task(s) as Text features to paste information copied from MS-Excel into Synchro.

  • Attach files
  • Christopher O'Neil commented
    May 31, 2017 19:16

    This did not work.

  • Admin
    Kate Hester commented
    May 31, 2017 19:31

      If you have 32-bit Microsoft Office installed, you will need to install the Microsoft Access Database Engine (x64) from the command prompt

    1. Open cmd.exe

    2. Copy the folder directory for the folder where AccessDatabaseEngine_x64.exe is downloaded

    3. In the command prompt, go to the folder by typing cd then right click to Paste the folder directory (eg. cd C:\Temp). Press Enter

    4. Run AccessDatabaseEngine_x64.exe with the parameter /passive (e.g. AccessDatabaseEngine_x64.exe /passive)  Press Enter

    Nothing will appear to happen because all installation dialogs have been suppressed. Check Windows Programs to verify that the program has been installed successfully

    See also Installing 32-bit and 64-bit Microsoft Access drivers next to each other and How to install 64-bit Microsoft Database Drivers alongside 32-bit Microsoft Office