I have a sql query file with couple of sql queries. select * from a; select * from b; when i am export this file into excel sheet. How do i name the sheets with the name of the table like sheet1 -->A sheet 2--> b please let me know

Naming Excel sheets when Exporting data from SQL Queries

JohnDorlon October 9, 2019, 1:57pm 15

I describe how to do it here: Export dataset multiple queries

Note that the ability to use the folder iterator was added for 13.2 beta (Sorry, I forgot about that earlier...was reminded when I looked up this other forum post)

Producing multiple files in Automation Designer

Topic		Replies	Views
Naming Worksheets, with multiple queries Toad for SQL Server	2	870	November 12, 2015
TOAD DATA POINT - Multiple queries export to Sheet1, Sheet2, Sheet3 etc ? I want to set my worksheet names as CUSTOMER , CONTACT instead of Sheet 1 , Sheet2 etc Toad Data Point & Toad Intelligence Central	5	3905	December 10, 2018
export to excel and name worksheets Toad for SQL Server	7	1700	July 22, 2011
Filename when exporting to Excel Toad for Oracle & DevOps Toolkit	0	496	January 28, 2011
TOAD Multiple grid export into one excel workbook Toad for Oracle & DevOps Toolkit	17	5669	December 8, 2022

Naming Excel sheets when Exporting data from SQL Queries

Related topics