Import TXT files

  • Thread starter lucianopaulinosilva
  • 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
 
N

Nikos Yannacopoulos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import txt files 1
Mail Merge Directory Conditional Page Break 0
Importing txt file 6
Merging from an Excel file with graphics 1
Read .TXT file line by line? 12
Cant Import "-" as txt 2
Importing multiple text files and getting certain figures. 3
Import all files in directory 1

Top