RE: Spool Oracle Tables into Excel Format

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 23 Sep 2002 05:13:19 -0800
Message-ID: <F001.004D6639.20020923051319@fatcity.com>

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
---------------------------------------------------------------------