Skip to main content

Hi All,

I am unable to connect Excel as Database. I have installed Microsoft Access Database Engine 2016 Redistributable but still facing the error.

Any help is much appreciated!!!

Error : Could not Connect to Database. Provider cannot be found. It may not be properly installed.

Connection String : 

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="file path";Extended Properties="Excel 12.0 Xml;HDR=YES";

Thank you

@sreelal 

Test using this driver:

https://download.cnet.com/microsoft-access-database-engine-2010-redistributable-64-bit/3000-10254_4-75452796.html

And string connection:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="full path to your xlsx file goes here";Extended Properties="Excel 12.0 Xml;HDR=YES"

 

Check the post below:

 

Regards


Thank you for your suggestions and assistance! I was able to resolve the connection issue by installing the correct version of the ODBC driver.


the version should be 32 bit only 


Reply