Delete matching items

[MrM121]

Hi, I am trying to import excel worksheets from one excel workbook. What I need to do is import one of the workbooks into a separate table, then I need to use the ID field in that table to delete all records in another table that is already in the database with a matching ID field.

I can do the import/export procedures, I just don't have a clue about the checking part, as described above.

Thanks,

Nick

 

[RiazKhanmohamed]

how about:

delete * from #database table name goes here#
where id in (select id from #excel table name goes here#)

 

[MrM121]

just tried it now, excellent.

Thank you