Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Unanswered: Batch script to run sql file and generate output in excel

    Hi,

    I have created a batch script that runs sql commands and generates output in excel. Now i have 4 sql scripts each gives a single output. How can i combine all the outputs in the same excel but different sheets. Currently i use spool C:\Script.xls to get the output in 1 excel sheet.

    Thanks in advance!!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle knows nothing about Excel or worksheets.
    Realize & understand that if Oracle client software is installed on the PC where Excel runs
    that via ODBC Excel can connect directly into the DB & issue SQL which eliminates the need for any external file to be created or read.

    GOOGLE is your friend; but only when you actually use it!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Also spooling to an xls file does not make an excel file. It is simply a csv file that will need to be converted by excel and it has no way to seperate into sheets.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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