I have a weekly task that involves exporting data for various users. I use a template database, created with Microsoft Access. The export includes SELECT * against (7) different tables the largest of which as about 1.3 million rows.This has been working fine in version 12.9 and 12.10.
The newest version of TOAD has a really annoying regression, in my opinion. If this change was made as a result of a request, then an option should have been provided to select the desired behavior. Each and every query I run results in the name of the table + ".mdb" as the default export database. For each query, I have to re-select the correct template file, which is a .accdb file format (not .mdb). Otherwise, I just spend a bunch of time creating (7) different .mdb files, instead of appending the results to empty tables in my single .accdb template file.
The first image shows the desired output filename (IRCS_Records.accdb):
However, after running a SELECT * on a table [e.g. SELECT * from custrequest_di_mbom; ], and then click on the Export Dataset button, I see the following:
No, I did NOT want the export file name automatically changed!
Also, please correct the misleading message shown below. The file does not get replaced depending on user options selected in the previous dialog; instead one appends rows to a table:
I noticed similar behavior when exporting to Excel. Also, the default Excel format should be the newer .xlsx format, not the older .xls format. We shouldn't have to always remember to specify the newer file extension.