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


ERROR in Creation : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.


I am using Windows Server 64 bit, MS Office 2010 64 bit.

Download and install 2007 Office System Driver: Data Connectivity Components using the following url.

This download will install a set of components that can be used to facilitate transfer of data between 2010 and 2007 Microsoft Office System files and non-Microsoft Office applications.


The above install will fix the error mentioned in this post.
It will work for both Microsoft Office 2010 and 2007.