Import TXT files

  • Thread starter Thread starter lucianopaulinosilva
  • Start date Start date
L

lucianopaulinosilva

Dear all,
I have a directory containing 10,000 txt files that I have to import
for excel.
Any file have two lines and I need that they appear in excel as the
following:
1-First column = File name;
2-Second column = Second line of all the txt files since the first line
contains only headers.

Filename Values
A.txt 235
B.txt 454
C.txt 475
D.txt 7854
E.txt 751
....

Do you have some suggestion about how could I do that?
Thanks in advance,
Luciano
 
Luciano,

You have ended up in the wrong NG, this one is for MS-Access, while your
question is on Excel.
Nevertheless, what you are asking is rather simple, so if you mail me a
few sample files, say 20 or so (zipped if possible), I'll put together
some code for you. Look for my mail address in the header of the post,
and do the obvious with it (basic anti-spam protection).

Nikos
 
Back
Top