RE: Spool Oracle Tables into Excel Format

[Naveen Nahata]

You don't need to get rid of the commas. A CSV file will automatically be read into excel and all the commas will become a breakpoint for new columns. Or alternatively a spooled output can be read into excel, it will open the format wizard to specify the breakpoints for columns

 

But the question is what if the comma is within the value of a column? In that case excel will create one more column. How to overcome that in a spooled CSV file?

 

Naveen

-----Original Message-----
From: Viktor [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 21, 2002 2:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:Spool Oracle Tables into Excel Format

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!