Merging data-tables.

[Guest]

Greetings,
IT has chopped the data I need into several files. The column headers are
the same for all 10 files. Is there a way to vertically merge these files
back together without going into the .txt files and copying 65,000 lines at a
time?

I would like to run a query once, and not ten times to get the results I'd
like. Any advice?

Many Thanks,
AtlantisArms

 

[David F Cox]

When you say "files" do you mean tables or comma delimited or something
else?

 

[Guest]

IT gave them to me as .txt/.csv. I've brought them into Access as tables.

Each of the ten files/tables is about 1.6 million lines long. (15 columns
wide, 1.6 million lines long.)

Does this help?

 

[David F Cox]

The first thing that strikes me is that that is a lot of data, and there has
to be some danger of exceeding the 2Gb size limit. The first advice is back
everthing up.
I would have the ten tables in a separate database from the destination
table, and link to them.
I would set up the destination table with every field defined as the minimum
size appropriate to the data.e.g no double precision where integer would do,
without being over zealous unlessl you had to be.

A simple Append Query to each table in turn should do the job for you.

Is that enough info for now?