Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Spool Oracle Tables into Excel Format

Re: Spool Oracle Tables into Excel Format

From: Jared Still <jkstill_at_cybcon.com>
Date: Mon, 23 Sep 2002 08:23:33 -0800
Message-ID: <F001.004D6A2B.20020923082333@fatcity.com>

This seems to be coming up a lot lately, and I've had to do it myself recently.

This is fairly easy to do with Perl. I think I posted something about this within the past month, so you may want to dig in the archives for some details.

Jared

On Friday 20 September 2002 14:03, Aponte, Tony wrote:
> 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-----
> Sent: Friday, September 20, 2002 4:33 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).
Received on Mon Sep 23 2002 - 11:23:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US