RE: Oracle to Excel

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 06 Nov 2002 12:10:17 -0800
Message-ID: <F001.004FD183.20021106121017@fatcity.com>

Brain freeze .... thats the only reason I did not think of it .... doh !

-----Original Message-----
Sent: Wednesday, November 06, 2002 1:39 PM To: Multiple recipients of list ORACLE-L

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-----
Sent: Wednesday, November 06, 2002 12:49 PM To: Multiple recipients of list ORACLE-L

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: Kevin Lange
  INET: kgel_at_ppoone.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 - 14:10:17 CST