.csv files into multiple sheets in one file [Closed]

Report
-
 Dass -
Hello,

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

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
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