Re: Spool Oracle Tables into Excel Format

And do not forget to use ... WHERE ROWNUM<65537 :-)))

JP

On Monday 23 September 2002 15:13, you wrote:
> 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

-- 
         Pruner Jan
       jan_at_pruner.cz
     http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

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