Merging 2 databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Clayton - 09 Feb 2004 06:49 GMT

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

Reply to this Message

John Vinson - 09 Feb 2004 17:57 GMT

>I have 2 databases which I would like to merge and make
>one database, most of the table fields are the same, as
[quoted text clipped - 10 lines]
>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!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

cats - 14 Apr 2004 22:36 GMT

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

Reply to this Message

John Vinson - 15 Apr 2004 06:46 GMT

>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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

Klaus L Jensen - 16 Apr 2004 08:55 GMT

??

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 : k.jensen@techotel.dk
Homepage : http://www.techotel.com
Phone : (+45) 36 19 21 41
Fax : (+45) 36 44 10 75

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

Reply to this Message