To read a multiple csv files along with headers

To read a multiple csv files along with headers;

Each file consists of 60 nos. of columns and I would like to store the whole data into a single excel file.

First row contains headers as characters, First column is of date and second column is of time stamp.

Pls any answer for this question

[Walter Roberson]

All of the data from all of the csv files is to be saved together in a single excel file? If that is correct then do you want the files saved side-by-side, columns 1:60 then 61:120, and so on? Or do you want them saved one after another, first file followed downwards by second file?

How do you want the date and time-stamp represented in the excel file? As strings or as excel dates ?

Please give an example line so we can see what the current date and time-stamp look like.

[sarfudeen]

yes all the csv files must be saved into asingle excel file; date and time stamp as execl dates

[Walter Roberson]

Please give an example line so we can see what the current date and time-stamp look like.

[sarfudeen]

My csv file look like this:- and wish to load multiple csv files

"date","time","period","ActPower (kW)_mean","ActPower (kW)_sigma","ActPower (kW)_max"

2012-07-04,00:10:00,600,568.399,149.409,1070.32,