how do I merge multiple csv files in one Excel file?
Copy all .csv files to a folder
Suppose you have copied that to c:\temp\
From command line within C:\Temp\ use COPY command as below to copy all to a
single file with a different extension...
COPY *.csv MyTest.txt/b
Open the newly create MyTest.txt in Excel and open as comma delimiter file....
If this post helps click Yes
---------------
Jacob Skaria
"Nedulous" wrote:
I have 200 csv files with data that I want to merge into one Excel file for
sorting purposes.
|