RE: Spool Oracle Tables into Excel Format

From: Inka Bezdziecka <IBezdziecka_at_cupe.ca>
Date: Mon, 23 Sep 2002 06:23:26 -0800
Message-ID: <F001.004D6765.20020923062326@fatcity.com>

I have never thought that I would ever suggest using GUI tool over a command line. Perhaps there is a first time for everything.

So, may I add to the list of good advices: use T.O.A.D. from http://www.quest.com/toad/ Disclaimer: I am not in any form affiliated with Quest Software nor I try to enforce or market its products. I have just found that I am too lazy to use SQL*Plus all the time.

inka

-----Original Message-----
Sent: Monday, September 23, 2002 9:13 AM To: Multiple recipients of list ORACLE-L

Bob,

All of the options stated by people from this list are excellent.

One thing that was not mentioned was that Excel can read any type of text file. It will notice that it is a text file, and will provide you with the opportunity to declare what the column delimiter is.

What this means is that you can use any character as a field delimiter, tell Excel what that column is, and it will convert the file for you.

By default, Excel likes the TAB char as a column delimiter. So, you can write your query as such:

select column1||char(10)||column2||char(10)||column3||char(10) from table_name.

Spool the output and name the file newfile.txt; start Excel, and file|open the file and follow the help wizard. I do this all the time.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, September 20, 2002 4:33 PM To: Multiple recipients of list ORACLE-L

All,

Is it possible to create Oracle reports into Excel format ?
Is it possible to spool Oracle tables into Excel format?

Thanks in Advance
Bob

---

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bob Robert
  INET: mssql_2002_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Inka Bezdziecka
  INET: IBezdziecka_at_cupe.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Sep 23 2002 - 09:23:26 CDT