Hi
Is there any ways to spool the results to an excel file format rather than a text format? :confused:
Printable View
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