How to delete all records while keeping the table

[Guest]

I could delete manually all records and keep the table structure. Is there a
macro that does this for multiple tables? Reason for doing this is my IT guy
is helping me to push weekly data but he needs the table to exist. Can't do
append as previous week data might change.

Thanks in advance for helping.

 

[Guest]

Hey Eddy - you can use delete quieries to get rid of the records in your
tables and then put those delete quieries in a macro to do it automatically.
You can also put criteria in the queiries to only delete the records you
need. If you want to append new information to those table put a key or
multiple keys in the tables so you don't append the same information. Hope
this helps