This topic is locked

error # -2147467259

5/31/2004 6:23:26 AM
ASPRunnerPro General questions
author

When trying to delete, I get the following error:

Error description [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM.
What can be the reason?
Thanks

Sergey Kornilov admin 6/1/2004

This problem happens because Excel is not a real database. Here is the excerpt from Microsoft Knowledge base article:

Delete

You are more restricted in deleting Excel data than data from a relational

data source. In a relational database, "row" has no meaning or existence

apart from "record"; in an Excel worksheet, this is not true. You can delete

values in fields (cells). However, you cannot:

  1.. Delete an entire record at once or you receive the following error

message:
  You can only delete a record by blanking out the contents of each

individual field.

  2.. Delete the value in a cell containing an Excel formula or you receive

the following error message:
  [color=red]Operation is not allowed in this context.

  3.. You cannot delete the empty spreadsheet row(s) in which the deleted

data was located, and your recordset will continue to display empty records

corresponding to these empty rows.


Full article can be found here