Exporting daily to report to One Excel File

[Mohammed Zenuwah]

Hi There,

I'm hoping you can help me. I have a Access query I would like to run each
day and export to a new tab within the same file each day, this table to
be labeled with the date of export, is there an easy way to to this?

Thanks in advance,

Mo..

 

[Alex Dybenko]

you can use docmd.OutputTo to export report, and define [Output Name] there
as:

"MyRep" & format(date(),"yymmdd")

 

[Mohammed Zenuwah]

Hi Alex,

Thanks for getting back to me, unfortunately I've never made use of
VBScript within MS Access and wouldn't know where to begin.

you can use docmd.OutputTo to export report, and define [Output Name] there
as: