Re: Spool Oracle Tables into Excel Format

[Tim Gorman]

Delimiting each column with surrounding double-quotes as well as commas is pretty standard...   Another standard approach is to delimit with a character that is less likely to be part of the data, such as the "tilde" or "~" character... ----- Original Message ----- From: Naveen Nahata To: Multiple recipients of list ORACLE-L Sent: Saturday, September 21, 2002 7:08 AM Subject: RE: Spool Oracle Tables into Excel Format 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!