how to delete all rows in table with temporary data

[Alex]

I need to fill out some table with temporary data.
I'm using append query to transfer data there. But, before
I need to delete old data.

I can delete the whole table and create a new one with the
same name and insert data there. But, it would be much
more easier just to delete all rows instead of deleting
and recreating whole table.
I would appreciate if anybody could advise whether the
approach like this exists and how it can be used.

Thanks

 

[456]

Alex,
the sql would look like this:
DELETE * FROM YourTable
This deletes everything from your table, but leaves the table structure
intact.
RD

 

[Alex]

Thanks a lot.

-----Original Message-----
Alex,
the sql would look like this:
DELETE * FROM YourTable
This deletes everything from your table, but leaves the table structure
intact.
RD




.