Combining mutiple files into ONE without "cutting and pastin

vampcatt · Feb 25th, 2002, 09:08 AM

OK Here is what I am trying to do, hopefully someone can help me with all my problems

I have a program that creates a csv output of inventory for me. I then run another program that converts it all to html.

HERE are my problems. The inventory I am gathering information on is from 8 regions, and 20 locations each. SO.. focusing on one region at a time, I have 20 separate "output csv" files, that I need to have combined into ONE file. I have manually combined all the files, with the good old cut and paste, BUT, that taints the "cell information" I have found that once I get all the files into ONE file, my HTML generator, will no longer function.

IS there a way to append to a file? or combine them, without cutting and pasting?
ALL files have the same cell size, column width etc, so they are similar in structure, just not data within the structure. Merging shouldn't be a problem.

I appreciate any help or suggestions.
( I don't know how to use the VB very well, and I think it would cause the html generator to no longer function also, so I don't think VB is the way for me to go.

THANKS!!

vampcatt · Feb 25th, 2002, 10:07 AM

I guess in really simple terms, in case my question was confusing.

say I have :
sanjose.csv
sanfrancisco.csv
monterey.csv
cupertino.csv
losgatos.csv
santaclara.csv

and I WANT to take them all and combine them into california.csv

HOW can I do that, without having to cut and paste each document manually?
Is there a way to make a new document called "california" and somehow "import" the data from all the other files??

Thanks in advance!

Mark W. · Feb 25th, 2002, 10:12 AM

Why not use a system editor (e.g., EditPlus, BBEdit) to append the files and then save the resultant file as "California.csv"?

Aladin Akyurek · Feb 25th, 2002, 10:13 AM

Maybe you can use free ASAP utilities for this, which is downloadable from:

http://www.asap-utilities.com/

by using its Import option, first to Excel, then Merge and Export.

Hope this helps.

vampcatt · Feb 25th, 2002, 10:44 AM

Downloading now.. THANKS!
Sounds like exactly what I need

Anne Troy · Feb 25th, 2002, 11:17 AM

Word should be able to do this too. You could record a macro that will do it for you.

Open the first file, then insert-file (choose next file), then insert... until all are inserted. Save the file as text or csv, then open from Excel.

Feb 25th, 2002, 11:17 AM	#6
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Word should be able to do this too. You could record a macro that will do it for you. Open the first file, then insert-file (choose next file), then insert... until all are inserted. Save the file as text or csv, then open from Excel. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 09:08 AM	#1
vampcatt New Member Join Date: Feb 2002 Location: State? Insanity! :) Posts: 26	OK Here is what I am trying to do, hopefully someone can help me with all my problems I have a program that creates a csv output of inventory for me. I then run another program that converts it all to html. HERE are my problems. The inventory I am gathering information on is from 8 regions, and 20 locations each. SO.. focusing on one region at a time, I have 20 separate "output csv" files, that I need to have combined into ONE file. I have manually combined all the files, with the good old cut and paste, BUT, that taints the "cell information" I have found that once I get all the files into ONE file, my HTML generator, will no longer function. IS there a way to append to a file? or combine them, without cutting and pasting? ALL files have the same cell size, column width etc, so they are similar in structure, just not data within the structure. Merging shouldn't be a problem. I appreciate any help or suggestions. ( I don't know how to use the VB very well, and I think it would cause the html generator to no longer function also, so I don't think VB is the way for me to go. THANKS!!

Feb 25th, 2002, 10:07 AM	#2
vampcatt New Member Join Date: Feb 2002 Location: State? Insanity! :) Posts: 26	I guess in really simple terms, in case my question was confusing. say I have : sanjose.csv sanfrancisco.csv monterey.csv cupertino.csv losgatos.csv santaclara.csv and I WANT to take them all and combine them into california.csv HOW can I do that, without having to cut and paste each document manually? Is there a way to make a new document called "california" and somehow "import" the data from all the other files?? Thanks in advance!

Feb 25th, 2002, 10:12 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Why not use a system editor (e.g., EditPlus, BBEdit) to append the files and then save the resultant file as "California.csv"?

Feb 25th, 2002, 10:13 AM	#4
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	Maybe you can use free ASAP utilities for this, which is downloadable from: http://www.asap-utilities.com/ by using its Import option, first to Excel, then Merge and Export. Hope this helps.

Feb 25th, 2002, 10:44 AM	#5
vampcatt New Member Join Date: Feb 2002 Location: State? Insanity! :) Posts: 26	Downloading now.. THANKS! Sounds like exactly what I need