Importing Multiple individual txt files into one single spreadsheet using 2003 Excel

I have numberial raw data taken from a monitoring stations. Currently when I import the data utilizing the excel 2003 importing feature which sets the delimiters within for the data which is 145 rows and up tothe V column. And that is successful however I was wondering if there is a way within the Excel spreadsheet that multiple files could be imported instead of doing it one by one.

Am a little frusted and thinking maybe Excel is the wrong way to go... oh well if someone has a brillian and
even better idea, I am open to it.

appreciate the help.

ed

look and try the...

Data menu ->Get External Data -> it will display "Text Import Wizard" -> follow steps there.
then you can consolidate if you want the text converted to xl data into one sheet or what ever purpose it may serve you.

I went to the Data menu/Get External Data-> NO Import Wizard, but only Import which takes me to where I select the file.
Then the Text Delimiter Wizard dialog box pops up. Which is how I was importing it to begin with....however how do I get more
then one file to be brought in instead of one.... only because i have 200 to import and wanted to to it all at one time....maybe a
macro i think.... :-)

is there another way.....

appreciate it.

ed

ah . i see multiple files at once.
maybe the link below with the code could help.

http://www.excelforum.com/excel-prog...beginners.html


regards,
vladimir