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

Issue:

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

Solution


For version 12.0 you need to install MDAC 2010 from  here.

This has to be done on the server where you publish your application. You need to install the x86 version if the target machine is 32 bit or the x64 version if the target machine is 64 bit and your application is built with configuration.

Reference

http://stackoverflow.com/questions/11179905/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine