UTL.FILE may have size limit issue. I found it's easy just using sql plus, set delmiate as ",", and spool to a file.

On 2/24/2006 7:13 PM, Chris Koenig <oracledba-ezmlmshield-x3491633.[Email address protected] wrote:
>If it can be a .csv (comma separated values, which auto-associate
>with
>excel in windows) and not excel, you could do it easily in PL/SQL
>using
>the UTL.FILE package or do it all in a .sql file, just have it spool
>your output to a .csv file, and concatenate commas between each field
>you select. Then call SQL+ from a .bat file or a unix .sh script
>and
>schedule it..
>
>-----Original Message-----
>From: Singer Mark A
>[mailto:oracledba-ezmlmshield-x91210466.[Email address protected]
>
>Sent: Friday, February 24, 2006 3:28 PM
>To: LazyDBA Discussion
>Subject: Batching Excel
>
>I have a requirement to periodically run a batch program to move
>data
>from a table into an Excel file. I can do this manually using Excel
>macros but I have not figured how to do this in batch mode. Does
>anyone
>have a solution?
>
>
>Thanks,
>
>
>Mark
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>


Oracle LazyDBA home page