Error related to Microsoft.ACE.OLEDB.12.0
Posted: 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
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