Excel connection string for ODBC provider

excel
database
activities
connection

#1

hi,

i am facing the error in connecting excel (while using update query for multiple row item)

Message: Cannot create and populate list type System.Data.Odbc.OdbcErrorCollection. Path ‘$values’, line 1, position 175.

Source: NewtonSoft.Json

Exception Type: JsonSerializationException

I have used ODBC as the provider

could u please let me know the perfect and exact connection string for connecting excel (odbc provider) so that i can eliminate this issue…


#2

Hey @debashishcapg

Driver={Microsoft Excel Driver (*.xls)};dbq=C:\Users\akshay.yadav\Desktop\Book1.xls;fil=excel 8.0;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;

Regards…!!
AKsh


#3

still now working akshay…

using .xlsx file

after connecting trying to retireve data using select query

“Select * from [Sheet1$]”

not working


Connecting excel with oledb and odbc providers
#4

Hey @debashishcapg

Because on your system only Microsoft excel(.xls) driver will be installed. so it will work with only .xls files.
first you have to install driver to support .xlsx. then you will be able to connect.

One more thing might be possible. the permission on a system. if you will use DSN in your connection string then if at the time if connection string generation user permission rule will follow so it might not work on other system due to permission issues.

Regards…!!
AKsh


#5

Hey @aksh1yadav,

Do you have a solution for the same?

Thanks,
Jiban