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 7.1 with an Excel data source
|Article:TECH158045|||||Created: 2011-04-13|||||Updated: 2011-04-13|||||Article URL http://www.symantec.com/docs/TECH158045|
When trying to use a Data Connector 7.1 data source to use an Excel file, the error "Failed to load list of tables/sheets. The 'Microsoft.ACE.OLDEDB.12.0' provider is not registered on the local machine." occurs.
Data Connector 7.1
Microsoft does not provide a 64-bit version of the Microsoft OLDEDB.12.0. Installing the 32-bit version onto the 64-bit Symantec Management Platform 7.1 does not enable it to work.
Download and install the Microsoft Access Database Engine 2010 Redistributable (64-bit) from the following Microsoft page:
Afterwards, open a Data Connector data source, point it to an Excel file, and the error no longer appears. The workbook pages can now be accessed.
Note: For 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 page:
2007 Office System Driver: Data Connectivity Components
Article URL http://www.symantec.com/docs/TECH158045