Consolidating data

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

Guest

I have 27 separate databases which I want to sonsolidate the same table into
one big table in a the consolidation database.

I created a consolidation database with the same table design with no data
and linked all 27 tables coming from these 27 databases.

Is there a way to consolidate them into the one table?

I know I can do it using append queries, but this is quite manual.

Thanks in advance,

Arnon
 
Very simple, assuming all of these are structured the same way, with the
same field in the same order.

Select table # 1, hit CTRL C, (copy) then hit CTRL V (paste.) This will
bring up the Paste Table AS dialog box. From here, choose "Append Data
to Existing Table", enter the name of that table under Table_name, and
hit OK.

Lather rinse repeat for all 27 tables.

Hint. Rename the Destiniation table "B", That way you just hit CTRL-C,
CTRL-V, B, click "Append Data" and OK. This will speed up the process.
When you are done, rename B back to it's original name.
 
Back
Top