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.
Page 1 / 1
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 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 -
Can you share a screenshot of your ODBC connections both 64-bit and 32-bit?
References:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.