SSAS Tabular import from Excel: The provider 'Microsoft.ACE.OLEDB.12.0' is not registered. RRS feed

  • Question

  • The provider 'Microsoft.ACE.OLEDB.12.0' is not registered.
    The following system error occurred:  Class not registered 
    A connection could not be made to the data source with the DataSourceID of 'a602f8fc-601a-496c-8957-1ec2573111b0', Name of 'Excel File6'.
    An error occurred while processing the partition 'Sheet1_4a7dfac0-bffd-4799-b0f6-844f76c31919' in table 'Sheet1_4a7dfac0-bffd-4799-b0f6-844f76c31919'.
    The current operation was cancelled because another operation in the transaction failed.

    I tried installing AccessDatabaseEngine.exe using /passive and AccessDatabaseEngine_x64.exe using /passive.

    I have office 32 bit on a 64 bit workstation.

    I can open the Excel file and click preview and see the columns, but the actual import throws that error.

    Any thoughts or ideas?  Installing both or either AccessDatabaseEngine file with /passive didn't help.


    Wednesday, September 23, 2015 5:49 PM


All replies