Re: Best way to Extract Data from Oracle into Excel

From: prasad yammanur <pyammanur_at_houston.rr.com>
Date: Fri, 18 Feb 2005 02:23:12 GMT
Message-ID: <kkcRd.8965$cW2.2772@fe2.texas.rr.com>

Hank,

I have used this
(http://www.oracle.com/technology/products/bi/spreadsheet_addin/index.html) Spreadsheet add-in in my
previous job. It worked good. Installation takes less than a minute and you can connect to Oracle OLAP data. Try this and see if it serves your purpose.

regards
Prasad Yammanur

"Hank" <hank755_ca_at_yahoo.ca> wrote in message news:58619410.0502152142.48630166_at_posting.google.com...
> 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 - 20:23:12 CST