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

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?

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

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




Spanic wrote:

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

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

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

"Dave Peterson" wrote:

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




Spanic wrote:

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