Re: Best way to Extract Data from Oracle into Excel

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 16 Feb 2005 01:39:16 -0800
Message-ID: <1108546756.360295.111010@z14g2000cwz.googlegroups.com>

Hank wrote:
> 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

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 Received on Wed Feb 16 2005 - 03:39:16 CST