Connecting excel with oledb and odbc providers

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

Please refer the solutions in this link