Combining mutiple files into ONE without "cutting and pastin
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Combining mutiple files into ONE without "cutting and pastin

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     


    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!!

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,785
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    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.

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com