Re: spool excel file with sql*plus
From: scott wojan <scottno-spam_at_wojanware.com>
Date: Sat, 18 May 2002 02:17:56 GMT
Message-ID: <oRiF8.28423$gD6.41610_at_sccrnsc01>
Date: Sat, 18 May 2002 02:17:56 GMT
Message-ID: <oRiF8.28423$gD6.41610_at_sccrnsc01>
"bb" <b_map_at_hotmail.com> wrote in message
news:4a6ed956.0205170218.e9ea03b_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)
Check out the Oracle COM Cartridge.
-- ************************ Scott Wojan Check out our HTML Editor "<blink>" Your tool in the fight against browser incompatibility! http://www.wojanware.com/pls/wojanware/blink.htmReceived on Sat May 18 2002 - 04:17:56 CEST