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