Question

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

+1

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

+9

@sreelal

Test using this driver:

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

+1

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

+1

the version should be 32 bit only

Sign up