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

Hank wrote:
A lot can be said about MS but their office tools are excellent
neighbors among themselves i.e. Access, Excel, Word etc. So going from
Access/Excel to Oracle over ADO/OLEDB will be a good option. Then you
have a choice to present data in any of the tools without loosing any
formating.

Crystal reports also has a pretty good engine and works seamlessly with
Oracle.

Regards
/Rauf

On 15 Feb 2005 21:42:32 -0800, hank755_ca (AT) yahoo (DOT) ca (Hank) wrote:
I use Oracle Objects for OLE.
http://www.oracle.com/technology/sof...ole/index.html

You have an example here:
http://builder.com.com/5100-6388-5219076.html


Xavi
--
Dain bramaged

Salut,

Is there realy a BEST WAY?

"Hank" <hank755_ca (AT) yahoo (DOT) ca> schrieb im Newsbeitrag
news:58619410.0502152142.48630166 (AT) posting (DOT) google.com...
Try alternative OpenOffice you may use in Unix/Linux/Solaris Environment
too!

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.

OpenOffice has a nice DataExplorer which is much more comfortable.

have a look at www.openoffice.org

Matthias

hank755_ca (AT) yahoo (DOT) ca (Hank) wrote in
news:58619410.0502152142.48630166 (AT) posting (DOT) google.com:

PERL can interoperate with Oracle (& many other DBs) & Excel.

Oracle has a program called Discover which is an ad-hoc/customizable
report tool which also has a EXCEL feature to xfer the output into a
excel spreadsheet

TOAD also has this extract feature

Good Luck

George

Never used it, but always thought it looked interesting:
http://www.oraxcel.com/projects/sqlxl/

jg
--
@home.com is bogus.
Just went through big stupid project to make online thingee agree with
stupid excel.

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


"Hank" <hank755_ca (AT) yahoo (DOT) ca> wrote

Hank wrote:

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@x.washington.edu
(replace 'x' with 'u' to respond)

"Matthias Huebner" <info (AT) verkehrsberatung (DOT) net> wrote



.... at all? Almost all of -est belongs to ideal (not substantial)
category of abstracts.

[... sorry ...]

--
test,
WS1-UANIC