Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Best way to Extract Data from Oracle into Excel

Best way to Extract Data from Oracle into Excel

From: Hank <hank755_ca_at_yahoo.ca>
Date: 15 Feb 2005 21:42:32 -0800
Message-ID: <58619410.0502152142.48630166@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.



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
Received on Tue Feb 15 2005 - 23:42:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US