Without knowing anymore about your files or locations, you can start with
this code from Chip Pearson's site:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy

"tmort" wrote in
message ...

I would like to be able to import data into one spreadsheet from
multiple text files. The data from text file 1 would go into specified
columns, the data from text file 2 would go into other columns and so
forth.

Can anyone help me with this?

Thanks


--
tmort
------------------------------------------------------------------------
tmort's Profile:
http://www.excelforum.com/member.php...o&userid=21053
View this thread: http://www.excelforum.com/showthread...hreadid=483114