ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing from multiple text files (https://www.excelbanter.com/excel-programming/345017-importing-multiple-text-files.html)

tmort[_15_]

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


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


Tom Ogilvy

Importing from multiple text files
 
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





All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com