MS Access 2010 - ExportwithFormatting Action
Posted on 2011-02-25
Looking for what I have wrong here. I am have built a macro to export data from a table, then run a delete query to remove the records. I need to save the export by date (this routine will run nightly) The Output File is set to
"z:\Data_" & Format(Date(),("dd-mm-yyyy") & ".xlsx"
However I am receiving the follwoing error:
"Microsft Access can't save the ouput data to the file you've selected." (error: 2302)
Can anyone tell me what I have wrong?