How to perform a Save As or Export data results to an Excel file or Instance for many different select or query statements? I would like the do this in one-step process.
TDA can export data results from different or multiple queries; however it would not be done in the Editor window. Please go to Tools Menu | Export | Export Wizard | click Next | then choose either â€Queryy†or â€Query Filee†| then complete the Export Wizard. Your query results will be placed in one Excel Sheet per query.
Note: If you choose â€Queryyâ€, you will have to copy and paste your multiple query statements (see example below) in there because the Enter Key does not bring you to the next line... it brings you to the next page of the Export Wizard. In addition, ensure that each query statement is ended with †; â€. You will also have the option of choosing other Output Formats like CSV, Delimited Text, etc.
Example multiple queries:
select * from customer
where state = 'CA'
and slsrep_no < 427;
select * from countries;
