Re:Spool Oracle Tables into Excel Format

[Viktor]

By the way, would you use replace to get rid of the commas withiin fields so that Excel reads it properly?

 [EMAIL PROTECTED] wrote:

Bob,

You can create a CSV file from SQL*Plus with the following statement:

select ||','||
from
where <......................>;

Dick Goulet

____________________Reply Separator____________________
Author: Bob Robert <[EMAIL PROTECTED]>
Date: 9/20/2002 12:33 PM

All,

Is it possible to create Oracle reports into Excel
format ?
Is it possible to spool Oracle tables into Excel
format?

Thanks in Advance
Bob

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Robert
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego! ! , California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB! ! ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

---

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!