Error related to Microsoft.ACE.OLEDB.12.0

Technology specific object identification, supported applications, web technologies, and 3rd party controls.
vivek.guvva
Posts: 31
Joined: Mon Feb 22, 2016 7:21 pm

Error related to Microsoft.ACE.OLEDB.12.0

Post by vivek.guvva » Thu Apr 07, 2016 10:17 pm

Hi,

I am trying to import data from excel to data table. When use the below connection string, I am getting the error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." Please let me know how to resolve the issue.

ConnectionString =
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & File & ";Extended Properties=""Excel 12.0 Xml;HDR=YES"";"

My Computer is 64 bit and Microsoft Office is 32 bit.

Thanks
Vivek

User avatar
RobinHood42
Posts: 240
Joined: Fri Jan 09, 2015 3:24 pm

Re: Error related to Microsoft.ACE.OLEDB.12.0

Post by RobinHood42 » Fri Apr 08, 2016 12:33 pm

Hi,

I found a lot of blogs how to resolve the issue when searching for your error message in Goolge.

https://social.msdn.microsoft.com/Forum ... rum=vstsdb
https://www.connectionstrings.com/the-m ... l-machine/
http://www.mikesdotnetting.com/article/ ... al-machine

I hope this will help you solving your issue.

Cheers,
Robin