Oracle-L: RE: Oracle to Excel

From: Rodd Holman <roddholman_at_hotpop.com>
Date: Wed, 06 Nov 2002 11:39:08 -0800
Message-ID: <F001.004FD0AF.20021106113908@fatcity.com>

Is there a reason why you can't just extract it directly in to Excel using ODBC or Oracle Objects for OLE? ODBC would be the easiest, OO4OLE will give you the most control and better macro scripting for auto updating. Both of these come with the Oracle client install.

Rodd

On Wed, 2002-11-06 at 13:12, Kevin Lange wrote:

Without extra software the easiest way is to setup a delimited file in a sql statement and spool output to a file. Then import the file into a spreadsheet.

If you have it, Toad will save data into spreadsheets for you.

        -----Original Message-----
        From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com]
        Sent: Wednesday, November 06, 2002 12:49 PM
        To: Multiple recipients of list ORACLE-L
        Subject: Oracle to Excel
        
        
        
        I think I have seen traffic concerning the extracting of data
        from Oracle into an Excel spreadsheet.  We now have a need for
        this.  Could anyone enlighten me?
        
        Thank you in advance.
        
        Laura

--

Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
roddholman_at_HotPOP.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rodd Holman
INET: roddholman_at_HotPOP.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 Wed Nov 06 2002 - 13:39:08 CST