Re: Best way to Extract Data from Oracle into Excel

From: Alan <>
Date: Thu, 17 Feb 2005 09:50:20 -0500
Message-ID: <>

I use Lotus Approach. Also, almost every reporting tool can do this.

"Hank" <> wrote in message
> 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
Received on Thu Feb 17 2005 - 15:50:20 CET

Original text of this message