How to Save or Export multiple SQL query statement data results in different Sheet Tabs in one Excel file? I want one Excel file to contain my multiple queries in different Sheets.
1) Perform a query and click the “Export Dataset” icon (or right-click the data grid results | click “Export Dataset”)
2) Choose “Excel Instance” under Export Format:|
3) Under “Sheet Name” | type: i.e. Query_01
4) Click OK
5) An Excel Instance will open with your Query_01 results in it
6) DO NOT CLOSE THE EXCEL INSTANCE THAT IS OPEN
7) Now, run another query in Editor and then do steps 1 to 6 again, but give it a different “Sheet Name” i.e. Query_02.
8) After you click OK, you will notice that the same Excel Instance now contains your Query_01 sheet tab and Query_02 sheet tab.
9) Keep on doing the above until you are done with your queries
10) Now perform a Save As on the open Excel Instance to save all those queries in one Excel file
