Wednesday, June 5, 2013

How To Merge Multiple CSV Files Into Single CSV File Using Command Prompt

While Uploading CSV Files To Database You May Find Unformated Data In CSV File While You Copy Manually. So To Avoid Such Condition We Can Merge Multiple CSV Files To Single CSV File Without Any Format Errors.

So We Have Two Csv File To Merge.
Go To Start Menu,Open A Command Prompt.And Next Direct The Command Prompt To file directory where the csv files are contained.So All I need to do is type "CD \MergeCsv".
Next For Merging the Csv Files use the following commands
"Copy *.csv file3.csv"

Finally you can find the merged file in the same folder with file3.csv ,