Updating/Deleting Data in several Access tables

[F15]

Using the DoCmd.TransferSpreadsheet, I am pulling several spreadsheets into several tables in my database. Each table has an ID number for each data record that links the data across the tables.

As time goes on, I will need to update the data. When the new data for ID 10 (for example) comes in, I would like to delete any existing data for ID 10. How do I delete the existing records in all my tables prior to transferring in the new data?

Thanks.

 

[mp9]

Try this query to delete everything from your existing table:

DELETE * FROM YourTableNameHere;

http://www22.brinkster.com/accessory/