Article ID: 316475 - View products that this article applies to.
This article was previously published under Q316475
When you edit an Excel worksheet through ADO and ODBC, you may receive the following error message if you use an ADO DataControl object:
If you use a Recordset object that is generated with ADO code, you may receive the following error message when you edit an Excel worksheet through ADO and ODBC:
[Microsoft][ODBC Excel Driver] Operation must use an updateable query.
Run-time error '-2147467259(80004005)': [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
This problem occurs if you try to edit a worksheet that is saved or opened as ReadOnly.
NOTE: ReadOnly is the default setting for an ODBC connection to Excel, with or without a data source name (DSN). Therefore, the user must always change that setting to edit data.
To resolve this problem, use the following methods:
Steps to Reproduce the Behavior
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/257819/ )HOWTO: Use ADO with Excel Data from Visual Basic or VBA
Article ID: 316475 - Last Review: February 12, 2007 - Revision: 2.2