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.
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.
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:
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
How to create a Data Connector data source that accesses data in an Excel spreadsheet through OLEDB
Issues occur when using a Data Connector import rule that uses an data from an Excel spreadsheet
How to import data into the Symantec Management Platform database using Data Connector