ODBC guide

Delete sheet rows


Deletes one or more rows from a sheet by ID. You can supply a single ID or a comma-separated list of IDs.

DELETE FROM [My Sheet] WHERE Id=7522710866202500 
--WITH(IgnoreRowsNotFound='true' --or false)		
--Or
--DELETE FROM [My Sheet] WHERE Id='7522710866202500,7522710866202501,7522710866202502'
--WITH(IgnoreRowsNotFound='true' --or false)