Specify ReadOnly using Microsoft Excel ODBC Driver

Connection string

This Microsoft Excel ODBC Driver connection string can be used for connections to Excel 97, Excel 2000, Excel 2002 and Excel 2003.

[Microsoft][ODBC Excel Driver] Operation must use an updateable query. Use this connection string to avoid the error.

Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\MyExcel.xls;ReadOnly=0;

ReadOnly = 0 specifies the connection to be updateable.