There were some posts recently suggesting the spooling of the columns using a comma as a separator. But check out this article in XML Journal (http://www.syntelinc.com/syntel/english/00000072/SYNT_XMLjrnl.pdf). It shows how to build preformatted Excel reports with XML, but it requires Excel 2002.
HTH
Tony Aponte
-----Original Message-----
From: Bob Robert [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Spool Oracle Tables into Excel Format
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).