Wednesday, June 15, 2011

Merge Multiple CSV Files | Zorba the Geek

 

Useful tip of the day – merge multiple files….

You can merge multiple csv or text files with a simple DOS command. Copy the code below into a text editor and save the file with a .bat extension. Save the file in the same folder as the csv files.

copy *.csv importfile.csv

I've used this as part of an import routine. Step one produces a set of csv files from SQL queries on an Oracle database. Step two merges all the csv files together. Step three imports a single file into Sage MMS

Merge Multiple CSV Files | Zorba the Geek

No comments: