Re: Best way to Extract Data from Oracle into Excel

Salut,

Is there realy a BEST WAY?

"Hank" <hank755_ca_at_yahoo.ca> schrieb im Newsbeitrag 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.

Try alternative OpenOffice you may use in Unix/Linux/Solaris Environment too!

>
> 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.

with OpenOffice you may export directly to xls-books (Save As) without the loss of any formatting.
also all edited formula will be translated to excel formulas.

>
> 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.

OpenOffice has a nice DataExplorer which is much more comfortable.

>
> Does anyone have any ideas/comments regarding the above mentioned
> techniques? What other approaches are there?
>

have a look at www.openoffice.org

> Thanks in advance,
> H

Cordialement
Matthias Received on Wed Feb 16 2005 - 09:30:38 CST