Re: How to export table and load into EXCEL use TOAD??
- From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Apr 2007 07:50:27 -0700 (PDT)
----- Original Message ----
From: dba1 mcc
To: oracle-l@xxxxxxxxxxxxx
Sent: Thursday, April 26, 2007 3:08:54 PM
Subject: How to export table and load into EXCEL use TOAD??
We have TOAD 9.0 version. Can anyone tell me how to
use TOAD to export table and save as format which
EXCEL can accept (possible csv)?
Thanks.
__________________________________________________
I can tell you that in TOAD 8.6.1.0 you can
- open the schema browser
- select Tables (the default)
- select the table of your choice
- Rightclick and select Save As
- choose either delimited (option 1 for me) or XLS (option 7)
- if saving to XLS, you may want to fiddle with options, in particular:
-- Include SQL statement (saved to a separate worksheet)
-- Include column headers
-- Date format (by default it uses MM/DD/YYYY - we prefer DD/MM/YYYY in UK; you
can exclude time if you like)
-- and don't forget to set a filename
-- check "Launch file after creation" if you want to see the file
- Press OK
The next time you use Save As it will remember the options you last set.
I imagine that TOAD 9 should be similar.
HTH
Regards Nigel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
