Merging 2 databases

[Clayton]

I have 2 databases which I would like to merge and make
one database, most of the table fields are the same, as
well as some data is the same, the 2 databases are named
DHA and DHA life, I have imported all tables,queries and
reports into the DHA database, I have a form witch I have
updated to display data from 2 tables, the tables
being "Clients" and "Client table", the "Clients" table
was imported from the DHA life database,the Primary Keys
for these two tables are both "CLient ID"
the problem Im having is that when I try and display the
data from both tables on the "Clients" form it only
display the data from the "Client table" table,
is there no easier way to merege these 2 databases,
please help

 

[John Vinson]

I have 2 databases which I would like to merge and make
one database, most of the table fields are the same, as
well as some data is the same, the 2 databases are named
DHA and DHA life, I have imported all tables,queries and
reports into the DHA database, I have a form witch I have
updated to display data from 2 tables, the tables
being "Clients" and "Client table", the "Clients" table
was imported from the DHA life database,the Primary Keys
for these two tables are both "CLient ID"
the problem Im having is that when I try and display the
data from both tables on the "Clients" form it only
display the data from the "Client table" table,
is there no easier way to merege these 2 databases,
please help

You MAY be able to run an Append query to append all the clients in
the Client Life table into the Client table.

If the ClientID was an Autonumber in both databases, though, this can
and will be a complicated operation! You will have conflicting ID
values in the two tables, and in their related tables. There may also
be problems if the same person exists in the two tables, either with
identical data or (worse) somewhat different data - you may need to
decide whether "Ralph Jonson" in [Clients] is the same person as
"Ralph Johnson" in [Client table] who's moved to a new address, or a
different person.

Without knowing more about the nature of these tables or what you've
done with this new form, it's hard to be more specific; but I'll warn
you that this is one of the harder jobs in managing databases!

 

[cats]

Can you, how do you merge two tables from one or two databases?

 

[John Vinson]

Can you, how do you merge two tables from one or two databases?

You'll need to post more information.

You can use File... Get External Data... Import to import a table from
one .mdb file into another; or, you can use File... Get External
Data... Link to connect to the second database, and run an Append
query to add data from the second table into the first one. If the
databases have related tables, or Autonumber ID's, you may have some
complications with duplicate ID's.

 

[Klaus L Jensen]

??

SELECT INTO newtable1 * FROM db1.dbo.table1 (NOLOCK) UNION SELECT * FROM
db2.dbo.table1 (NOLOCK)

Then rename newtable1

????


Shoud this not work!


Med venlig hilsen
Klaus Ladegaard Jensen
TECHOTEL
E-mail : (e-mail address removed)
Homepage : http://www.techotel.com
Phone : (+45) 36 19 21 41
Fax : (+45) 36 44 10 75