Automatically export table named as current date

[kaseu]

Hi,

I have a database that runs a report daily and creates a table (make-table query) with the results. I need to export this table into an Excel spreadsheet and save it as the current date. I'd like to set the database up to do this automatically. I thought I had seen another thread weeks ago addressing this problem, but couldn't find it. Any help would be GREAT! Thank you!!!

 

[M8KWR]

instead of doing a make table query, why don't you just export the query to an excel file.

export the query or table using the following

Dim Dataexport 

Dataexport = Date ' the name of the file

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Name of Table or Query", Dataexport, True

Hope this helps