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.
Post a Comment