|  | Combine Tables | | |
| | | Chi |  |
|  Posted: Thu Sep 04, 2008 1:08 pm Post subject: Combine Tables |  |
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 | |
| | Posted: Thu Sep 04, 2008 1:12 pm Post subject: Re: Combine Tables | |
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:07E8BDED-1A2B-4713-A8DD-4402362373D6@microsoft.com...
| Quote: | 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
|
|
| |
| | | Fred | |
| | Posted: Thu Sep 04, 2008 1:30 pm Post subject: RE: Combine Tables | |
| |  | |
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" wrote:
| Quote: | 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
|
|
| |
| | | Chi | |
| | Posted: Thu Sep 04, 2008 1:41 pm Post subject: Re: Combine Tables | |
| | | |
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" wrote:
| Quote: | 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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:07E8BDED-1A2B-4713-A8DD-4402362373D6@microsoft.com...
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 | |
| | Posted: Thu Sep 04, 2008 2:24 pm Post subject: Re: Combine Tables | |
| | | |
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:5D88FD67-C7F2-4882-9908-90B5D2B9A4F5@microsoft.com...
| Quote: | 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" wrote:
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:07E8BDED-1A2B-4713-A8DD-4402362373D6@microsoft.com...
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
|
|
| |
| | | Fred | |
| | Posted: Thu Sep 04, 2008 2:54 pm Post subject: Re: Combine Tables | |
Jeff,
FYI, I hadn't seen your original response when I wrote mine.
Fred |
| |
| | | Chi | |
| | Posted: Thu Sep 04, 2008 3:03 pm Post subject: RE: Combine Tables | |
| | | |
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
"Fred" wrote:
| Quote: | 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" wrote:
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
|
|
| |
| | | Chi | |
| | Posted: Thu Sep 04, 2008 3:07 pm Post subject: Re: Combine Tables | |
| | | |
Hi Jeff,
Yes, It is very important. Thank you for trying to help me!
Thanks
Chi
"Jeff Boyce" wrote:
| Quote: | 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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:5D88FD67-C7F2-4882-9908-90B5D2B9A4F5@microsoft.com...
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" wrote:
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:07E8BDED-1A2B-4713-A8DD-4402362373D6@microsoft.com...
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 | |
| | Posted: Thu Sep 04, 2008 3:19 pm Post subject: Re: Combine Tables | |
| | | |
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:1BDC517E-C518-4B00-9193-356F0E635F88@microsoft.com...
| Quote: | Hi Jeff,
Yes, It is very important. Thank you for trying to help me!
Thanks
Chi
"Jeff Boyce" wrote:
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:5D88FD67-C7F2-4882-9908-90B5D2B9A4F5@microsoft.com...
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" wrote:
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
"Chi" <Chi@discussions.microsoft.com> wrote in message
news:07E8BDED-1A2B-4713-A8DD-4402362373D6@microsoft.com...
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 | |
| | Posted: Thu Sep 04, 2008 3:20 pm Post subject: Re: Combine Tables | |
Your questions make good sense. I often find myself asking for more info
before trying to figure a direction...
Jeff
"Fred" <Fred@discussions.microsoft.com> wrote in message
news:2D319FE7-2809-4FF7-A80C-4EC59B73F180@microsoft.com...
| Quote: | Jeff,
FYI, I hadn't seen your original response when I wrote mine.
Fred |
|
| |
| Page 1 of 2 .:. Goto page 1, 2 Next | |
|
|
