RE: How to export table and load into EXCEL use TOAD??

From: Ken Naim <kennaim_at_gmail.com>
Date: Thu, 26 Apr 2007 14:23:00 -0400
Message-ID: <00c901c7882f$ecdc00b0$0200a8c0@kenlaptop>

In toad it is quite easy to save it as a csv or xls file just right click any data grid (table or query result set) and click save as and pick csv or xls. Also you can choose option as headers, whether you want text data quoted etc.

Other way is to pick the table(s) from the schema browser and right click, then save as and continue as above.

Ken Naim

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Thursday, April 26, 2007 10:09 AM
To: oracle-l_at_freelists.org
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.

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 26 2007 - 13:23:00 CDT