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





Oracle LazyDBA home page