.csv files into multiple sheets in one file

John - May 14, 2010 at 05:42 AM
 Dass - Oct 25, 2010 at 12:47 AM

I have a set of .csv files (reports generated in mainframe) which I want to put into one file, one sheet pr. csv-file (report).
Is that possible? and in case, how?

I would be gratefull for any answers.

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 14, 2010 at 06:03 AM
So you have a bunch of csv that you want to import into excel. Each csv should be a new sheet ?

For that a macro is needed. Also you have to think about how a macro would know which csv is to be imported
Hi , Just login into Windows Command prompt

and c:\cd test
suppose under test folder u have multiple *.csv files

c:\test\copy *.csv target.csv
this DOS command copies all *.csv files in test folder to Target.csv excel file