Error "Failed to load list of tables/sheets. The 'Microsoft.ACE.OLDEDB.12.0' provider is not registered on the local machine." occurs when trying to use Data Connector data source with an Excel spreadsheet

Article:TECH158045  |  Created: 2011-04-13  |  Updated: 2014-04-04  |  Article URL http://www.symantec.com/docs/TECH158045
Article Type
Technical Solution


Issue



When trying to use a Data Connector data source (an OLEDB data source) with an Excel spreadsheet, the error "Failed to load list of tables/sheets. The 'Microsoft.ACE.OLDEDB.12.0' provider is not registered on the local machine." occurs.


Environment



Data Connector


Cause



Altiris requires Microsoft Access Database Engine 2010 Redistributable (64-bit) to be installed on Symantec Management Platform server in order to access data in an Excel spreadsheet externally from the Excel software.


Solution



Download and install Microsoft Access Database Engine 2010 Redistributable (64-bit) (AccessDatabaseEngine_x64.exe) from the following Microsoft website onto the Symantec Management Platform server:

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

Afterwards, open a Data Connector data source, point it to an Excel file or in the "Worksheet name" field, click on the Refresh button and the error should no longer occur.

Note: For legacy 32-bit versions of Data Connector, this error refers to the missing Microsoft OLDEDB.12.0 on the Altiris server. This can be downloaded at the following Microsoft website:

2007 Office System Driver: Data Connectivity Components
http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

Related Articles

How to create a Data Connector data source that accesses data in an Excel spreadsheet through OLEDB
http://www.symantec.com/business/support/index?page=content&id=HOWTO95482

Issues occur when using a Data Connector import rule that uses an data from an Excel spreadsheet
http://www.symantec.com/business/support/index?page=content&id=TECH206995

How to import data into the Symantec Management Platform database using Data Connector
http://www.symantec.com/business/support/index?page=content&id=HOWTO79380




Article URL http://www.symantec.com/docs/TECH158045


Terms of use for this information are found in Legal Notices