Delete

Sammy31
04-16-2004, 10:05 AM
I have the following statement as part of my code, but it gives me the error "Deleting date in a linked table is not supported by this ISAM"

conn.Execute ("DELETE * FROM [sheet1$] WHERE JobNo = '" & r & "'")


Any Suggestions,

Shurik12
04-16-2004, 10:43 AM
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:
Delete an entire record at once or you receive the following error message:

Deleting data in a linked table is not supported by this ISAM.
You can only delete a record by blanking out the contents of each individual field.
Delete the value in a cell containing an Excel formula or you receive the following error message:

Operation is not allowed in this context.
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.



From:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;257819#RetrieveExcel

Sammy31
04-16-2004, 12:16 PM
got it, thank you

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum