appending multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

. Reply (E-mail) Forward (E-mail)

Subject: Appending multiple tables
From: "(e-mail address removed)"
<[email protected]> Sent: 5/31/2004
12:15:24 AM




I have taken on a new role where I have control of 7
databases on different sites. I want to create master
tables with data from each database. Is there a way I can
append all the tables into the master table at one go
rather than appending them one by one?

Many thanks

GLS
..
 
I have taken on a new role where I have control of 7
databases on different sites. I want to create master
tables with data from each database. Is there a way I can
append all the tables into the master table at one go
rather than appending them one by one?
Click to expand...

Well... that depends.

If they are just one-table databases (possible, but unusual), and if
they do not contain duplicate Primary Keys in the different tables,
you can create a UNION query to splice all seven together and then
base an Append query upon the UNION query.

If the databases have multiple linked tables, Autonumber keys,
possible duplicate data, possible ALMOST-duplicate data (such as "Rob
Jones" and "Robert Jones" being the same person in two databases),
etc., it can be many hours of work.
 
Back
Top