Moving records from one table to another

[filnigeria]

i want to copy the whole of one table (which is a temporary one) to the main
table
i want to do this before i delete the temporary tables
i have the delete scripts and all that all i need is how to move them before
i delete them

 

[Ron Weiner]

Why not execute a Query that does the heavy lifting. Something like

INSERT INTO tblMain SELECT * FROM tblTemp

might do it for you if the data structire of both tables are the same.

Ron W