Toad World® Forums

Add date to excel export templates


#1

Hello,

I’m trying to automate an export of a access table into an excel file and have it so the date is appended to the end of the file.

There appears to be an option for this on the excel export options of the wizard which I’m using to create my export template. However whenever I select it nothing happens. The file comes out as the table name without the appended date information.

What am I doing wrong?

-m


#2

Looks like you found a bug. The work around would be to be use the Select To File activity. You will need to have a SQL file or Query Builders file that selects * from this table. The date suffix works in this activity.

I have entered CR 67,079 to fix this issue.

Debbie


#3

This is now fixed but missed this weeks Beta. It will be in the following week’s TDA 2.6 Beta posting.

Debbie