+ Reply to Thread
Results 1 to 4 of 4

Thread: Spool to excel

  1. 05-26-2003 04:58 AM #1
    mooks
    mooks is offline Senior Member
    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?
    Reply With Quote Reply With Quote
  2. 05-27-2003 02:12 AM #2
    andrejm
    andrejm is offline Junior Member
    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
    Reply With Quote Reply With Quote
  3. 05-27-2003 05:45 AM #3
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  4. 05-27-2003 05:30 PM #4
    eugene
    eugene is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width