Exporting daily to report to One Excel File

  • Thread starter Mohammed Zenuwah
  • Start date
M

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..
 
A

Alex Dybenko

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

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

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.


Alex said:
you can use docmd.OutputTo to export report, and define [Output Name] there
as:
Click to expand...
 
Top