PRB: "Operation Must Use an Updateable Query ... - Microsoft Support

[Microsoft][ODBC Excel Driver] Operation must use an updateable query. If you use ... Open "TB1", cn rs.AddNew rs.Fields(1).Value = "New Value" rs.Update rs.

support.microsoft.com