Consolidating data

[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

 

[Phil]

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.