Copying all data from one table to another

[JaySang]

I'm wondering how i would copy all information from one table to another exact same table.

Its for a history, that whenever things are more than 6 months old, it will copy to the other database keep the main one small and organized

any ideas or suggestions
Thanks in advance for all your ideas!!!

 

[IcesMaster]

You can use Make Table querry. For example" You want to copy TableA to New table calles Table B

SELECT * INTO TableB
FROM TableA;

 

[JaySang]

Is it easy to copy all data from a specific date ?