MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

DELETE Statement Limitations

The DELETE statement is not supported for the Microsoft Excel or Text driver. Note that the INSERT statement is supported for the Text driver.

The dBASE driver does not 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).