Spool to excel

Hi

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

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

Or you can make an ODBC connection to your database via Excel to return the results directly to the spreadsheet.

HTH

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