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 |
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