Ranorex Forum

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

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