How can i import multiple .csv files into Excel for analysis?

[Guest]

I need to copy multiple .csv files into Excel so that i can analyse the
information. The .cvs files are on CD, there are many of them and i do not
wish to open each one and then have to save them. Any clues?

 

[Dave Peterson]

I'd shell to DOS and then copy all the .csv files to one .csv file on my
harddrive. Then open that one file:

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

 

[Guest]

Dave - Many thanks. I never considered reverting back to good old DOS. It
worked a treat once i could remember the syntax. Thanks...