Easy SQL question.

[Glen]

I am SQL stupid and I need some quick help. I need to take all the
information from one table and insert it into another table for
archiving. The tables have identical structures but have different
functions.

This is what I am trying to do:

SELECT * INTO tblmaterials FROM tblTempList

or

INSERT INTO tblMaterials VALUES tblTempList.*

or something like that.

I just need to take all of the materials from the temp list and add to
an established archive table. Thanks for any help.

 

[Guest]

Try

INSERT INTO tblmaterials
SELECT tblTempList.*
FROM tblTempList

 

[Glen]

Thanks a lot Ofer. You rock!