Connecting excel with oledb and odbc providers

database
activities

#1

I connected to excel using odbc provider. I am getting format exception error sometimes while using update query.
I know by using oledb as provider we can eliminate this error. Just want to check if there is any parameters that we can use in our connection string in odbc to remove the same.

My connection string :
“Dsn=Excel Files;READONLY=FALSE;dbq=” & SelectedFile


#2

Please refer the solutions in this link