Merge 2 DBs - dif. structure ..Need help

[norcim]

I need to merge two Access DBs but I need to know if it is even possible before I start learning how to do it. It is not easy for me to express the problem but here goes:

DB A:
-Flat Table with numbered indexes
-will use a unique field as my index for the merge
(not the primary key)

DB B:
-The destination
-One to Many relation (table 1 to table 2)
-primary key not numbered field (I think)
-will match primary key to the unique field in DB A
-a few fields from DB A will be appended to table 2

....................DB B
Table1----------------Table2
******---------------************
*-----*-one to many-*-------------*
******---------------*-------------*
-----------------------*-------------*----append----------DB A
-----------------------************...<<<<<<<......***********
--------------------------------------------------------*-----------*
--------------------------------------------------------***********

 

[gromit]

Hi -

Not clear if I fully understand the question, but I'll try to help.

Are you really trying to merge records (data) from db A, or fields (table structure)?

What exactly are you bringing in from dbA? (A single table? multiple tables?).

Can you post a simplified db that illustrates the structure of what you are trying to move?

In general, if you can match up records between two tables, you can perform a merge. The tables can be in different db's (although as a first step, I would just import the smaller table into the db with the larger one).

If the structure of the two tables is different, then I would probably first alter the structure of the destination table to look like what you want, then merge records into it.

Sorry if that's vague. Post back if you have more questions.

- g