How to delete rows from a excel using OLEDB

How to delete rows from a excel using OLEDB? I tried with开发者_如何学运维 Delete from [sheet1$] but it's not working.

I know this is old, but I recently ran into the same problem:
It is not to delete using OleDb with Excel

From http://support.microsoft.com/kb/316934

Although the Jet OLE DB Provider allows you to insert and update records in an Excel workbook, it does not allow DELETE operations. If you try to perform a DELETE operation on one or more records, you receive the following error message...