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

Last Reply on Sep 10, 2013 02:49 AM By Pradip

Posted on Sep 10, 2013 02:07 AM

I have done a simple coding to show excel data in gridview it is running in one system but in another system it is giving error:

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

how to correct it..

Posted on Sep 10, 2013 02:08 AM

You need to download and install Office Components from here

 


Posted on Sep 10, 2013 02:49 AM

The setup you described appears to be correct. I would verify the install by checking the below path to insure that the data provider exists:

"C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL"

 

and 

refer

http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine