Error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on x64 systems
Last Updated June 09, 2016
When creating a Data Connector Data Source using an excel spreadsheet (.xls or .xlsx), following error is seen.
The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
The dll mentioned in the error must be registered on the notification server (NS). This dll is installed with Office 2007 and later but must be the x64 edition of MS Office when installed on a 64-bit server.
There are two methods to resolve this issue.
Install MS Office 2007 x64 or later x64 version of MS Office.