| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Multiple XML Files into Excel | Excel Discussion (Misc queries) | |||
| import multiple csv files into excel 2007 | Excel Discussion (Misc queries) | |||
| Import of multiple .CSV files into Excel | Excel Programming | |||
| Excel VBA - Import Data for manipulation from multiple text files | Excel Programming | |||
| Import multiple text files into excel | Excel Programming | |||
Hybrid Mode
