Page 1 of 1

Error related to Microsoft.ACE.OLEDB.12.0

Posted: Thu Apr 07, 2016 10:17 pm
by vivek.guvva
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

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

Posted: Fri Apr 08, 2016 12:33 pm
by RobinHood42
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