Error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on x64 systems

Article:TECH168219  |  Created: 2011-08-26  |  Updated: 2011-09-19  |  Article URL http://www.symantec.com/docs/TECH168219
Article Type
Technical Solution


Issue



When creating a Data Connector Data Source using an excel spreadsheet (.xls or .xlsx), following error is seen.

I was not able to get a screenshot, please insert one if this is seen again.


Error



The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine


Environment



Symantec Management Platform 7.1 and later
Barcode Solution 7.1 and later


Cause



The dll mentioned in the error must be registered on the system.  This dll is installed with Office 2007 and later but must be the x64 edition of MS Office when installed on a .64 server.


Solution



There are two methods to resolve this issue.




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


Terms of use for this information are found in Legal Notices