Importing from multiple text files

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>