SQL queries can be executed to Microsoft Excel. Check this article for more information.


However, the delete query is not supported in Excel. The reason for that is because in a relational database, "row" has no meaning or existence apart from "record"; in an Excel worksheet, this is not  true. You can delete values in fields (cells). 


One workaround is to use the update query to set the rows as null, then use the select query to retrieve all not null rows

For example, lets say we have the following excel file:



and we want to delete the row #4. The the SQL query would look like this:


update [Sheet1$] set [A]=null,[B]=null,[C]=null where [A]='3'


Then, in order to retrieve all not null rows we would execute the following SQL Query:


Select * from [Sheet1$] where [A] not null AND [B] not null AND [C] not null


The result will be a data table variable with all the data of Excel except for the desired row.