Toad World® Forums

Export Data Results and Code to Excel

Hi everyone - I'm sure this has been asked here many times before, but I searched and couldn't find an answer. Sorry if this a repost.

I'm using Toad Data Point 5.1.6.206 (64bit).

After running a query and getting the results, is there a way I can export the data and the SQL query to Excel at the same time? I run many reports, and I'd like to be able to include the query for each report on another tab in Excel.

Any help is appreciated. Thank you!

Right-click off your data grid contents and choose the Export Wizard, and then check the "Include SQL Statement" box per snap below.

Second snap shows that you'll get two tabs in your Excel workbook, one has the data, and the other has the SQL statement used to create the data.

1 Like

Gary.Jerep - Thank you so much for the information and screenshots. That worked perfectly.

I noticed some other options in the menu that could be beneficial to me, so I will be taking a look at those as well.

Much appreciated!

1 Like