Re: spool an Excel file

From: Gregory N. Mirsky <gmirsky_at_optonline.net>
Date: 17 May 2002 08:51:16 -0700
Message-ID: <31eb00e7.0205170751.2f3d85a4@posting.google.com>

Check out the stored procedure OWA_SYLK on the Oracle web site 'Ask Tom' at
http://asktom.oracle.com/pls/ask/f?p=4950:8:838178::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:769425837805,%7Bowa_sylk%7D

It will generate the data as *.slk format that can be opened directly by Excel with the user not having to convert anything. We use it all the time.

Greg

b_map_at_hotmail.com (bb) wrote in message news:<4a6ed956.0205170217.36630db3_at_posting.google.com>...
> Is there any posibility to make a spool file in the right format for
> Excel?
> Just from sql*plus. So i open a dos-batch file which opens sqlplus and
> runs a statement like 'select * from dual' and i'll wil get an .xls
> file on my C: which contains an 'X'
> I really need a real excel formatted file, which does not have to been
> imported in excel. I.e. from TOAD you can save directly to an Excel
> file. This is what i wanna do in a batch without using TOAD. (So, no .csv file)
Received on Fri May 17 2002 - 10:51:16 CDT