I think I have your answer - here's the design for two tables
named Order_Extract and Order, both containing the exact same layout:
Column Names
- ORDER_ID, Long
- ORDER_DATE, Date/Time
- SHIP_DATE, Date/Time
Assuming that you want to delete all entries from the Order
table that match in the Order_Extract table, here's the SQL that will do that:
DELETE FROM Order
WHERE ORDER_ID IN
(SELECT ORDER_ID FROM Order_Extract)
Let me know if you'd like to have the VBA code to do it
as well.
Hope that helps.
|