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”
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:email@example.com]
Sent: Friday, February 16, 2018 11:52 AM
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.
Unsubscribe from Toad Data Point Forum notifications altogether.
Toad Data Point - Discussion Forum
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.