Concatenating multiple text files

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

Guest

I have a problem that I've been wrestling with... I get a number of large
text files (variable number of files ranging in size from 30-50MB) from
clients that I need to concatenate together. They're all in the same format,
but they all have column headers in them, so I can't simply copy the whole
file. I tried using TextStream to copy the file line by line, but it's too
slow with this many large files.

Can anyone recommend a method that might be relatively easy to write, but
that will be fast?

Thanks,
Chris
--
 
Hi

You could import the file into a table and then run a delete query to
delete rows which contain the headings - I'm assuming they are easily
identifiable. Alternatively if they are always the 1st row, run a
delete query to delete the first row.

Regards
James
 
The thing is, I need to have an intermediate text file, so what I want to do
is build a text file and then link to it in Access. Any suggestion on how I
can do this by manipulating the text files?

Thanks,
Chris
 
Back
Top