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?