Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Unanswered: Excel Files merge into one XLS file

    Hi,

    I have generated few files with .CSV extension from Microsoft SQLserver2000. Client wants them to be in one XLS file with different worksheets for each of these files. How can I do it?

    Thanks
    Vinnie

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    I hope I understand what you are asking. If this is a one-time event, then save the first file as an Excel workbook, not csv, that way you can have extra worksheets (csv files allow only one worksheet). As you open all the other csv files (you can do it at one time), right-click and choose "Move or Copy" and click the box below to "Create Copy" then select the original XL file (you saved above) as destination.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    simply open the generated text files FROM Excel, specify "," (coma) as the column separator, then combine all sheets into one file by copy them (right click the sheet tab and copy)

    cheers
    qha_vn

  4. #4
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Excel files

    Many thanks for the suggestions. I did not put exactly what I wanted. Is there any command from the command line I can use ( Windows command line ) which can combine the .csv files into one .csv or .xls file? I do not want to open and do copy/paste.

    Thanks
    Vinnie

  5. #5
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    go here and see if it fits your need and......... budget

    http://www.softinterface.com/Convert...nate-Files.htm
    qha_vn

Posting Permissions

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