Best way to Extract Data from Oracle into Excel

[Quoted] [Quoted] I'm looking at ways to generate reports based on data in an Oracle [Quoted] [Quoted] database. This data will be viewed in Excel.

[Quoted] [Quoted] I've looked at Oracle Reports and Oracle Discoverer as possible tools, [Quoted] [Quoted] but reports created in either of the 2 applications lose their [Quoted] formatting upon exporting to Excel.

[Quoted] [Quoted] Another method is to use VBA and ADO to connect to Oracle and extract [Quoted] the data directly into Excel where the reports can then be formatted.

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

Thanks in advance,
H Received on Wed Feb 16 2005 - 06:42:32 CET