The easiest way.. is to MERGE the CSV files FIRST, then open the MERGED file in Excel.
Let's suppose you have 3 files saved in a folder
Like:
Jimsproducts.csv
Joesproducts.csv
Bobsproducts.csv
You saved them in a folder, like C:\SavedAttachments
You can run a command like this using the DOS prompt.
Click START, click RUN, type CMD
This will give you a black screen of DOS.
Now type copy c:\SavedAttachments\*.csv c:\SavedAttachments\Merged\Mergedproducts.csv
This COMBINES all 3 of the files together.. than saves the COMBINED file into one called, Mergedproducts.csv
I also added another FOLDER called, MERGED.. because you can't run the command (copy) in the same folder.. because the Mergedproducts.csv FILE is created when you run the command, so it is ALSO merged into itself...
So.. you use the COPY command.. you use *.csv (The ASTERISKS then a PERIOD, then CSV).. the ASTERISKS means.. ALL FILES, that end with CSV.
You probably have the answer for this by now..
-sapphire
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
