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.
+1The 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"
+1Glen Britto wrote:
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 -
+8Can you share a screenshot of your ODBC connections both 64-bit and 32-bit?
References:
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.