Problem:

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.
 

Solution:

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: December 10, 2016