I often come to the situation where I have like 100's of csv files and I need to compile these data into one. Suppose I have ADCP data and I need to compile all the ADCP data into one. The easier way I found so far is by using old DOS program.
Windows start button|Run
cmd (win2k or winXP)
command (win98)
copy d:\myfiles\*.csv c:\all.csv
exit
to get back to excel and open c:\all.csv
(Modify d:\myfiles to match your CD drive letter and path.)
The above command works perfect and after you import all the data into excel you can use some code to modify the layout of the data.
Windows start button|Run
cmd (win2k or winXP)
command (win98)
copy d:\myfiles\*.csv c:\all.csv
exit
to get back to excel and open c:\all.csv
(Modify d:\myfiles to match your CD drive letter and path.)
The above command works perfect and after you import all the data into excel you can use some code to modify the layout of the data.