Re: Best way to Extract Data from Oracle into Excel
Date: Wed, 16 Feb 2005 16:30:38 +0100
Message-ID: <42136720$0$17767$626a14ce_at_news.free.fr>
Salut,
[Quoted] Is there realy a BEST WAY?
[Quoted] "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 - 16:30:38 CET