Is anyone aware of any commands for purging of a table in an access database? That is, I would like to delete all the data in it but not the structure. I am at the moment working between two tables and constantly need to clear data in them. So what I am doing now is killing the table and recreating them again. Surely there must be a way of purging the data without having to recreate the whole table. If anyone has any suggestions, I would greatly appreciate it.

Thank you.
Ben
[email protected]