Query to copy a table? 2

[robojeff]

After making several updates to a table, I would like to make a copy of it and replace any copy that may already exist...

so, "My_tbl" would have a copy made of it called "My__tbl_1"

What is the best way to do this, by query or SQL statement?

Please give an example.

Thank you

 

[PHV]

SQL code:
SELECT * INTO My__tbl_1 FROM My_tbl

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886