Toad World® Forums

Exporting Multiple Result Sets in TDA



I was hoping to be able to run a query with multiple scripts that produce multiple subsets in one result set. Then export all these subsets to one worksheet in excel with one export command instead of accessing each subset to export. Am I missing something? Thank you,




Create a single *.sql file with multiple select statements. Use this sql file for the export and choose Excel as output. It will put the result of each select into a separate worksheet in the same Excel file.