Problem to delete table data in Excel

Question

I 'm trying to delete Excel table data by command

DELETE FROM [Phones_map$]

Then I got exception Additional information: Deleting data in a linked table is not supported by this ISAM.

Here is connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myfile.xls;Extended Properties="Excel 8.0;HDR=No;IMEX=0"

Is another SQL command supported by Excel for table data deletion ? I tried TRUNCATE table , but it does not supported
Thanks in advance

Since you're using an external data relationship, I'd suggest you that the correct approach to handle this data would be to import the data you need into a proper object / table / structure and then point your application to use this structure, rather than try to update the data directly in Excel. — Tiago Cardoso
Thanks for reply , but application will use DataTable or DataSet which should be afterwards to stored in the table , which is already existing . How can I tell that the existing data in table will be overwritten ? — lm.

paulmorriss paulmorriss · Accepted Answer · 2011-03-22T17:26:14

I think the error message gives you your answer - you can't delete the data.