When you try to download a file to a Microsoft Excel spreadsheet using the Microsoft Excel ODBC driver, you get the error:
-3035:  S1000: [Microsoft][ODBC Excel Driver] Operation must use an updatable query.


When you configured the ODBC data source and created the MS Excel ODBC driver entry for a Microsoft Excel spreadsheet, you forgot to remove the read-only flag.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: September 11, 2020