PowerPivot v2: Access provider not installed


  • I just upgraded to the new Powerpivot v2.  I am trying to get data from an access 2003 database.  When I specify the database and click "Test Connection" I get the following error:

    Error Message:

    Cannot connect to the data source because the Access provider is not installed.

    Call Stack:

       at Microsoft.AnalysisServices.Common.DataSourceBasic.ValidateProviderInformation()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)


    I can successfully load and refresh Excel data but I cannot connect to either Access 2003 or Access 2010 databases.  I have Office 2010 32 bit and it is fully patched.  I even installed the Access Data Engine 2010 thinking it would help but no.

    Any ideas how to troubleshoot this?  Do I need to revert to Powerpivot v1?


    Friday, April 06, 2012 10:13 PM


All replies