table to table import problem

[lpm]

I’ve got records in table “A” (488 fields) that I want to import into Table “A Archive” (488 fields) in the same file. Both tables have identical fieldnames in the same order. Actually, I created “A Archive” by duplicating (copy/paste) table “A” in manage database and renaming it. I just want to be able to dump the records from “A” into “A Archive”. Is there some magic that I need to do on the relationship graph or is there a trick to importing from “A” into “A Archive”? I haven’t been able to make it work. Also, I’m getting “” showing up in “A Archives” layout. Thanks for your help.

[IdealData]

Did you try File > Import records > File...

[Søren Dyhr]

I’ve got records in table “A” (488 fields) that I want to import into Table “A Archive” (488 fields) in the same file.

Ehm?? Who would need that, hardly normalised is it?? Please note this isn't a spreadsheet debates forum!

--sd

[rigman]

interesting... I'm trying to do the same. There should be a way of doing this without using set field, which seems overkill for a table with 488 fields.

In my case, I need to archive the old records that will no longer be used. By transfering those to the second table, users will still be able to view the old data in a second layout, while clearing the main table from the records no longer needed there.

[Søren Dyhr]

I wonder what the missing bit here is, import between tables inside a solution is just adding the file itself in the reference list??

--sd

[bcooney]

A database model you might want to consider is what is referred to as Type/SuperType.

Basically, you'd have a base table that has all the data. Then, you have two "satellite" tables that hold the IDs of a certain type. This will allow you to create a form/list view of just that type.

In your solution, I'd have three tables, ActiveItems, ArchivedItems, Items. It's terrific, because you do not move data between tables, you simply set IDs.

See Fenton's detailed description: Graham Method

[Søren Dyhr]

Ah that's right Barbara I'm not really getting anywhere mentally today ... it's the old story about management demanding starting all over on a new year with a new table...

--sd