RE: Oracle to Excel

[Kevin Lange]

Title: Oracle to Excel

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

-----Original Message-----
From: Rodd Holman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle to Excel

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:[EMAIL PROTECTED]]
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 [EMAIL PROTECTED]