Spool to excel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Spool to excel

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Spool to excel

    Hi

    Is there any ways to spool the results to an excel file format rather than a text format?

  2. #2
    Join Date
    Jul 2002
    Location
    Slovenia
    Posts
    42
    You can try with csv file and then open with excel...

    spool c:\temp\test.csv
    select empno||';'||ename||';'||job||';'||mgr||';' from emp;
    spool off
    Andrej

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Or you can make an ODBC connection to your database via Excel to return the results directly to the spreadsheet.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Jan 2001
    Location
    San Diego, CA
    Posts
    81
    or you can go to asktom.oracle.com and search for sylk package it will do it for you. I have it somewhere home and I used it ok , works fine.........

    CSV will do it too but sylk had the capability of changing fonts , colors, headers , etc.............a way cooler

    Eugene Roytman
    OCP

Posting Permissions

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



Click Here to Expand Forum to Full Width