.csv files into multiple sheets in one file Closed

Question

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.

Configuration: Windows 2003 / Internet Explorer 8.0

rizvisa1 · Answer

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

Dass · Answer

Hi , Just login into Windows Command prompt

and c:\cd test
suppose under test folder u have multiple *.csv files

c:	est\copy *.csv target.csv
this DOS command copies all *.csv files in test folder to Target.csv excel file

.csv files into multiple sheets in one file

2 responses

Subscribe To Our Newsletter!