I had the need to combine a number of CSV files into one to look at some data in Crystal Reports. I started trying to do something in Excel but it was going to take a lot of time to copy and paste the data.
I did a Google search and found the blog post below. It turns out you can use DOS. The first step is to put all the files into one directory. You then open CMD and change to that directory. You then run a command like “copy *.csv combine.csv”. Amazingly, it worked and the result was great.
Resources:
http://www.tomnash.eu/how-to-combine-multiple-csv-files-into-one-using-cmd/
