| | |
|
|
|
appending multiple tables |
|---|
| message from anonymous on 1 Jun 2004 |
. Reply (E-mail) Forward (E-mail)
Subject: Appending multiple tables
From: "anonymous@discussions.microsoft.com"
<anonymous@discussions.microsoft.com> 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
|
| John Vinson replied to anonymous on 01 Jun 2004 |
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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: appending multiple tables (Microsoft Access Database)
