+1Hi 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
+9Test 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
+1Thank you for your suggestions and assistance! I was able to resolve the connection issue by installing the correct version of the ODBC driver.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
