How to delete all records while keeping the table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddy - 23 Mar 2007 07:06 GMT

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.

Reply to this Message

holly - 23 Mar 2007 15:41 GMT

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

> 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.

Reply to this Message