Mar 22, 2013 8:28:00 AM by Debbie Peabody
Here are the basics on exporting to excel. We will build on this action in the next two videos to build complex reports.
When finalizing your SQL queries you might need to send the results to an end user.
The easiest way to deploy a report based on a SQL result is to export to excel. Toad Automation can help you build a variety of Excel reports ranging from simple data dumps to attractive complex reports. Let’s take a look at how to do this.
The Select to File activity is built to execute simple data dumps to Excel, csv or html.
If you want to run exports repetitively and keep all of the results you can append worksheets to an existing Excel file. Just remove the Overwrite option. You can also give each work sheet a name and append a timestamp. (In TDP 3.3 and above this option is available in the export wizard only) This is good if you want to compare the data in tables from a week to week basis. To do the compare you can use one of our compare tools.
However, you might want to run several queries and put them in the same Excel workbook but on different worksheet. You can do this by entering a script with all of your SQL In this case each SQL will be executed and be exported to separate worksheets.
Written by Debbie Peabody
Debbie Peabody is a Software Development Team Lead. She joined Quest in 1997 coding for Quest’s SQL Tuning product SQLab. She brings many years of experience of development on database tool products and co-designed Toad Data Point.