import data from another DB

[kioku]

so i need to keep 2 DBs with the same forms (But different data) for the purpose of single/double data entry. i have to constantly import forms from DB1 to DB2 because of the form changes, how do i keep the existing data and import it?

when i try to use the import wizard, it always imports the tables as duplicates. so here is the scenario if it helps to explain better:

1: import FORMS/TABLE structure only from DB1 to DB2
2: DB2 is EMPTY, no DATA, just forms/table copied from DB1
3: enter some data into DB2
4: DB1 forms is updated, so I have to re-import the forms to DB2
5: new DB2 is again EMPTY. how do I re-import JUST the DATA portion from previous DB2 version into new DB2?

hope this makes sense. please provide a step-by-step if possible. like what fields to check and how to use the import wizard. thanks very much!

 

[MarkK]

Why can't all the data be in one file?
Alternatively, why can't the forms stay in one file, and link in the tables from the other two files?
Having to import data as a necessary part of the actual workflow of a system seems like bad design, unless there is some constraint you haven't described. Do you need to distribute a file with only a sub-set of records or something?

 

[kioku]

no, it's not that i need subset of records.

i know it seems confusing, but there needs to be 2 separate DBs for the purpose of double data entry. the data is the same, it's just that the data input progress is slower in one than the other.

the forms are usually changed in one DB, and to avoid having to redesign, i want to import those forms to a separate DB (the 2nd data entry).