Delete Using Microsoft Query

Hi all,

Using Excel 2013.
Is it possible to delete some records from Sheet1 if the records exist on Sheet2?

I tried several SQL variations in MSQuery but all come back with error messages.

I tried:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

I keep getting these messages

SQL Query can't be represented graphically. Continue anyway?

and

Syntax error in FROM clause

thx
w

Bump.

thx
w

Don't know about 2013 but you can do it using VBA easily

Thx

Agreed. Even easier in Access or Management Studio (SSMS)
But I would like to figure out how to do it (if possible) using Microsoft Query.

thanks