How do I copy a table?

[J__]

Hi,

I have a table, which I created and I want to archive the data in that table to another table.

so table one is tasks table 2 is tasks_archive

2 qs: Since I already have the tasks table created is there a way to just say "copy task to task_archive" - so I can get the schema/field defs -- rather than having to type all the fields in again?

for archiving like I describe, I basically want to append a batch of records from one table to the other - is there a script step to do this or should I loop across back and forth between two layouts copying the fields ugggh!

thanks for your help in advance,

sincerely,

J__

[sbg2]

I wrote out the reply below but then realized you probably are working with a single file that contains multiple tables? I haven't seen a way to copy tables in the same file (Isn't that great?). Maybe its time to start working with multiple files?

_______________

original post:

File>Save a Copy As...

This will copy all tables in the file, if you have multiple tables in the file you may want to delete all but the archive file in the copy of the database. Delete all the records from the Copy(archive) then set-up an export from the original and import into the Copy(archive). You may want to use Update Matching records in your Copy(Archive) import to avoid duplicates.

[J__]

I want to copy the schema so I don't have to type it again, but I guess I just type it in.

as for updating the table as the user is using it, i guess a script under a button doing a loop is the only solution.

thanks for your help,

sincerely,

J__

[Ender]

What is the purpose of archiving the records?

I generally keep multiple year's data in the same file/table. If the records are no longer needed, they are removed. As far as having archives, these are simply the backup copies burned to CD or DVD.

[J__]

Hello Ender,

thanks for the response. that is a good point and I will consider that.

It is basically what was requested by the person i am helping out.

thanks for the suggestion and as I said I will consider it and see if that's ok.

sincerely,

J__