AnsweredAssumed Answered

Copy all records from a Table to an Archive Table

Question asked by gregdc on Oct 22, 2014
Latest reply on Oct 22, 2014 by philmodjunk

Title

Copy all records from a Table to an Archive Table

Post

I am looking for an easy way to take all of the records from one Table and pasting them into an Archive Table in a script.  I see the COPY All record request but I am not seeing how to PASTE them All into the Archive Table.  I looked through the forum, and it talks about import, but not Table to Table copying.   What simple thing am I over looking?

And just to keep things lively, is there a way to do this while adding a DATETIME Stamp to the Archived record so that I can know when the record was put in the Archive Table?

Outcomes