I am working with tDA 2.5.1, and have been trying to set up a simple automation script to export the results of the query to a new access database, and I’ve run into a few issues.
For the export step, I’ve tried using both Query and Query File. In both cases, Toad is using the actual script as the name of the table in access (e.g. “select * from table”). This causes it to fail if the script is not a single line. (if I do an export to access from the grid, the table is called Table1)
The “Edit selection template…” option sometimes doesn’t do anything. So far, though, I’ve not been able to pinpoint the set of circumstances that causes it (it seemed to occur most frequently after I’ve tried running the script, and it fails validation).
If I select “Create As New Table” from the Select Output Options screen, Read rows increment and File encoding are grayed out. However, if I switch back to Access File (or anything else), they are not reactivated.
I looked through the release notes for 2.6, but did not see anything related to this, nor did I find anything searching this forum. 2 and 3 are minor issues, but I see exporting to Access as being a feature we would use frequently. If you’ve got any suggestions for getting around that, please let me know.