Copy a table

[VBAhole22]

I have a script that takes 2 tables and compares them based on some criteria and then produces an output table with the results. I know that the format of the output table will always resemble the format(fields) of one of the input tables. How can I copy the input table change the name and then delete all of the records before I add the results in?
I am using Access 2k and unfortunately the whole thing is in DAO. Any suggestions?

 

[scottfarcus]

DoCmd.RunSQL ("SELECT tblExercise.* INTO tblNewExercise FROM tblExercise;")
DoCmd.RunSQL ("DELETE * FROM tblNewExercise;")