Toad World® Forums

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


#1

Is there a way to automate naming worksheets within sql or a toad option? As of now multiple queries export to Sheet1, Sheet2, Sheet3 etc ? I want to set my worksheet names as CUSTOMER , CONTACT instead of Sheet 1 , Sheet2 etc. Appreciate your quick help.

Thanks,Siva


#2

You can do this with TDP automation. When exporting to Excel, you can export multiple queries to the same workbook and name the worksheet as you suggested using the Advanced Export Properties dialog box. There is a “Worksheet Name” box that will allow you to specify the name for the current query’s output sheet.

For a short video of this, you can watch the following tutorial:

Exporting Data to Excel with Toad Data Point

http://www.toadworld.com/products/toad-data-point/m/media-library/1139

or

Automating complex Excel reports with Toad Data Point

http://www.toadworld.com/products/toad-data-point/m/media-library/1144


#3

Neither of those videos show you have to name multiple tabs on the export.

If I try entering a worksheet name, then it only exports the first query.

How do I set up an automated proc that exports 2 queries to the same excel sheet, separate tabs, and names each of those tabs???


#4

You can either create a template, name the tabs and then have 2 exports, one that exports the first sql code to “tab a” and then have it run the second code and send it to “tab b”

Or

You can have it run the first sql and save it to the xls and then run the second script when you’re creating your export, select append worksheet

From: alexlunar [mailto:bounce-alexlunar@toadworld.com]

Sent: Friday, February 16, 2018 11:52 AM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] 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

RE: 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

Reply by alexlunar

Neither of those videos show you have to name multiple tabs on the export.

If I try entering a worksheet name, then it only exports the first query.

How do I set up an automated proc that exports 2 queries to the same excel sheet, separate tabs, and names each of those tabs???

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point Forum
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

Confidentiality Notice This electronic message transmission contains information belonging to Magellan Health, its subsidiaries or affiliates, that is solely for the recipient named above and which may be confidential or privileged. MAGELLAN HEALTH, its subsidiaries or affiliates, EXPRESSLY PRESERVES AND ASSERTS ALL PRIVILEGES AND IMMUNITIES APPLICABLE TO THIS TRANSMISSION. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this electronic transmission in error, please notify us by telephone at +13143875539. Thank you.


Speak Up For Compliance

If you have a concern related to suspicious, illegal or unethical activity, you may also report it by calling MAGELLAN’S COMPLIANCE HOTLINE, 24 hours per day/7days
a week, at 1-800-915-2108. When calling, you may choose to remain anonymous, as an outside vendor manages the incoming calls. All calls will be treated confidentially and investigated.


#5

You can even have the tabs named by a variable, just put the variable name inside of #'s (#TabNameVariable#) in the worksheet name box. Depending on which version of Toad you are using you may need to hit the Advanced button in the Select to File to get to the worksheet name box.


#6

Perhaps an easier way to do this is to create one Export task with multiple individual exports that append each result set to the same Excel workbook. That way, you can name the worksheets anything you like. See snaps below. Hope this helps. Bring up the Export wizard
e.g. Tools-> Import Export Data-> Export Wizard
and when you are all done adding your individual extracts, make sure you save your work into an Export template file for use later on in your automation job.

I had the similar issue and Gary.Jerep from Quest helped me with this. The topic is “TDP V4.2 and higher -Automation Script exporting to Excel issue”

Thanks