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.