Re: How to export query results to excel
Fabrizio <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <2035410.1200941329325909031.JavaMail.SYSTEM@alvqcfw02> |
Message from: Fritz_ht Found a solution, from a temporary table a Toad Action export data in a fixed excel file, using a batch I call a stored procedure that empties and fills the table with data for current parameter, than I run Toad action via command line and rename the excel with parameter value. I was searching for a complete toad solution but this should do the work Fritz _______________________________________ Historical Messages Author: Fabrizio Date: Wed Feb 15 09:11:18 PST 2012 Found a solution, from a temporary table a Toad Action export data in a fixed excel file, using a batch I call a stored procedure that empties and fills the table with data for current parameter, than I run Toad action via command line and rename the excel with parameter value. I was searching for a complete toad solution but this should do the work Fritz __ Author: Fabrizio Date: Mon Feb 13 02:43:49 PST 2012 I need to export results from a query executed with different parameter to excel using each parameter as excel file name. For example I have to run a query with parameter XXXX and export the output to a file called XXXX.xls, then execute the same query with parameter BBBB and output to a file called BBBB.xls and so on. Can I do this using toad 9.5? I've looked to actions or command line execution but I'm not come up with a solution. Thanks, Fritz __ _______________________________________