Copy Entire Table to another Table 1

[jheiser]

I need to copy the entire contents of a table called shippingreport into a table called saveshiptable when i click a command button on my form, but I can only copy one record. After the copy is complete I need to delete all of the records in the shippingreport table.

 

[kmclane]

If you just need a one time copy, you can copy and paste with a new name. This will create an exact duplicate of your table with a new name. To delete all records in a table is a simple
DELETE *
FROM Tablename;

Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[PHV]

Something like this ?
DoCmd.RunSQL "INSERT INTO saveshiptable SELECT * FROM shippingreport;"
DoCmd.RunSQL "DELETE FROM shippingreport;"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jheiser]

That worked great thanks