Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Can you automate Toad to export multiple query results to a single Excel spreadsheet?
설명
I want to automate exporting multiple query results into Excel to create a multi-sheets report and specify what each sheet name should be.
해결 방안
WORKAROUND: Go to Export Wizard located in Tools | Export. There is an option to export to an Excel instance. From there you can choose the Excel file to import to and it will create a sheet with the name of the table, but unfortunately you cannot automate this nor can you change the name of the sheets.
STATUS: Enhancement request ST62288 has been submitted to Development for consideration in a future release of Toad for Data Analyst.
