Toad World® Forums

Select to File is creating multiple tabs. How to deactivate this option


#1

Hi,

In the automation task, I seleected the database activity, Select To File; when the tas runs, the results are saved in the same worksheet but different sheets. How can I deactivate this fucntion. Every time the task runs, I just want to save the results in the same sheet. Please advise. Thanks a lot


#2

Add an activity prior to the Select To File that deletes the excel file.

I will be adding the ability to append new worksheets or overwrite the original file in the next release. For now, you will need to add the delete file.

Debbie