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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Best way to Extract Data from Oracle into Excel

Re: Best way to Extract Data from Oracle into Excel

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 17 Feb 2005 08:38:36 -0800
Message-ID: <1108658143.99405@yasure>


Hank wrote:

> Hello,
>
> I'm looking at ways to generate reports based on data in an Oracle
> database. This data will be viewed in Excel.
>
> I've looked at Oracle Reports and Oracle Discoverer as possible tools,
> but reports created in either of the 2 applications lose their
> formatting upon exporting to Excel.
>
> Another method is to use VBA and ADO to connect to Oracle and extract
> the data directly into Excel where the reports can then be formatted.
>
> Does anyone have any ideas/comments regarding the above mentioned
> techniques? What other approaches are there?
>
> Thanks in advance,
> H

Just a quick caution ... if your organization is subject to Sarbanes-Oxley doing so could be illegal. Be very very careful.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Feb 17 2005 - 10:38:36 CST

Original text of this message

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