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


Error:


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


Solution:

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.

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

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