DELETE statement limitations
The DELETE
statement isn't supported for the Microsoft Excel or Text driver. The INSERT
statement is supported for the Text driver.
The dBASE driver doesn't support packing a table to remove "deleted" values.
For the Paradox driver to delete a row from a table, the table must have a unique index (Paradox primary key).