delete all records but keep table

[Eddy]

I need to delete all records in a table but keeping the table. This is to
allow new records to be push into the table by my IT admin (he is not
familiar with Access). Can't do appending data as past weeks data may
change. Any suggestions?

 

[Allen Browne]

Create a macro with the RunSQL action.

The statement to delete all records from Table1 is:
DELETE FROM Table1;

 

[Eddy]

Thanks for helping newbie! Exactly what I need.

Create a macro with the RunSQL action.

The statement to delete all records from Table1 is:
DELETE FROM Table1;