Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    insert a whole bunch of csv files (2003)

    I have a whole bunch, well 57 actually, of csv files from which I would like to create a single worksheet. Would the "copy con" command work to combine all of the csv files? Any other ideas?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: insert a whole bunch of csv files (2003)

    COPY CON is not appropriate here (as far as I can tell). However, if you put all .csv files in a single folder, say C:Text, with no other .csv files, you can open a command prompt window, and execute the following command line:

    COPY C:Text*.csv C:TextCombined.csv

    You can then open Combined.csv in Excel. You'll have to remove the last row (it contains the End-of-file character)

Posting Permissions

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