Combine Tables

[Chi]

Hi,

I have two identical databases- A and B (the tables are set up the same
way). The relationship is one to many. Would you please show me how I can
combine the data from the Database A to Database B.

Thanks
Chi

 

[Jeff Boyce]

We may need to discuss terminology first.

In MS Access, a "database" is all of the objects, not just the tables, and
not any one specific table.

Are you saying you have two tables that are identical in structure? If so,
how could the relationship be One-to-Many?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Fred]

An Access "database" is a container with a bunch of objects (tables, forms,
queries etc.)

If I make a guess at the implied question, the essence is that you want to
add the data from the tables in database "B" into the corresponding tables in
database " A" Presumably everything is identical between the correspnding
tables, including the rules and definition of the data that has been entered.


Now two questions:

1. Are any of the linking fields autonumber?

2. Do you have to look for and eliminate duplicated records?

3. Do you have a possibility that the values in the linking fields may be
duplicated between the two databases?



If the answer to #1 and #2 was "no", and #3 is "yes" then one way would be
to make a modification to all of the linking fields in all of the tables in
database "B" (add leading digits, double them, add a fixed number to them,
repeat the contents etc.), and then, using append queries, append each table
in "B" into it's twin in "A"


Sincerley,

Fred

 

[Chi]

Hi Jeff,

I created one database that has two tables and its relationship is
on-to-many for Education department and then I copied it for Radiology
department to use. Therefore, I have two databases that are identical in
structure.
Now is the time to combine data from Radiology department to Education
department. I think that I just focus on tables since they are stored data.

Thanks
Chi

 

[Jeff Boyce]

Fred's response offers further analysis and an approach.

Why are you doing this? That is, why add "Radiology" records to
"Education"? How will you know which is which? Is that even important?

And I still don't get "two tables and its relationship is one-to-many"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Fred]

Jeff,

FYI, I hadn't seen your original response when I wrote mine.

Fred

 

[Chi]

Thank you very much for your help. I know that it is complicated

1. Are any of the linking fields autonumber? Yes.

2. Do you have to look for and eliminate duplicated records? Yes

3. Do you have a possibility that the values in the linking fields may be
duplicated between the two databases? Yes

I will work on the #3 and let you know.

Thanks again
Chi






Chi

 

[Chi]

Hi Jeff,
Yes, It is very important. Thank you for trying to help me!
Thanks
Chi

 

[Jeff Boyce]

So how will you tell which record came from which database?

And what relationship is one-to-many?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Your questions make good sense. I often find myself asking for more info
before trying to figure a direction...

Jeff

 

[Fred]

There are several things in you posts that lead me to belive that you might
need to take a few steps back and answer these quesitons to yourself, if nto
to us:

1. What is the nature of the the process/information that your FINAL
database will database?


2. What do you want your database to accomplish?

3. Design a table / table definition structure that will be a good
foundation for doing the above.


4. Decide where your current data in your current tabl;es should go in the
the structure you designed in #3, and move it in there.


5. Design your queries, forms, reports, etc. to comple the fufillment of
your mission defined in #2.

Anything in your current databases that complies with the above can be used.



Sincerley,

Fred