Where are the advanced options for Select to File set up properties in Automation? For save to Excel, where are the options to enable/disable overwrite, name the worksheet, and append the worksheet to Excel document?
In Toad Data Point 3.2 there was an option for advanced setting but that is no longer an option in version 3.3.
RESOLUTION 1:
Upgrade to the most recent version of Toad Data Point. This is available here for download.
RESOLUTION 2:
Instead of using the "Save to File" activity. Use the "Export Wizard" activity. Choose to "Build Template" for the "Export Template" field. In that wizard, there should a page to select Excel output options and the expected advanced options.