Excel as Database Connection issue

Forum|Forum|1 year ago
December 11, 2024
4 replies
194 views

Not able to connect to the database, there is some error for the connection string/ driver, my system has 64bit driver installed. Getting the below error.

G

Glen BrittoAuthor

Cadet | Tier 2

The connection string which i have used is this - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""C:\Users\Glen\Documents\AA360\Excel DB.xlsx"";Extended Properties="Excel 12.0 Xml;HDR=YES"

G

Glen BrittoAuthor

Cadet | Tier 2

G

Glen BrittoAuthor

Cadet | Tier 2

The connection string which i have used is this - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""C:\Users\Glen\Documents\AA360\Excel DB.xlsx"";Extended Properties="Excel 12.0 Xml;HDR=YES"

the additional “” have been removed now im getting this error -