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 -> Re: Export Data in Oracle for MS Excel

Re: Export Data in Oracle for MS Excel

From: Shahzad Latif <shai_02_at_hotmail.com>
Date: 27 Dec 2001 07:16:58 -0800
Message-ID: <1f16721b.0112270716.53ee3283@posting.google.com> 





I am not sure what exactl you want. Here are a couple of solutions.
Hope they can help:



    
  
  1.   Use excel to import data (in 2000: Data ---> Get External Data --->
New Database Query)
OR
  
  2.   If you are using TOAD or SQL navigator etc., run your query and
then save it as a comma delimited file. Open the saved file (more or
less csv format) in excel.






Shahzad
Received on Thu Dec 27 2001 - 09:16:58 CST












Original text of this message













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