Running a query automatically/automating query and exporting proce

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a process which runs a query stored in Access once a
week without any human contact and exports this data into an excel
spreadsheet.

I have a few ideas but they would require me to redo everything that is
already here.

Thank you in advance!!
 
Hi,
i think best way is to build a separate mdb, which runs your query and
export in autoexec macro, and use windows task scheduler to run it every
week
 
If you use the Windows Task Scheduler, the PC has be turned on anyways.
When I was in cube-city, Outlook was always open. Separate from that, if
Outlook is shut down and the duedate/time for the task passes, the
Reminder event will fire with Outlook is next opened. I'm now currious
of the capabilities of Exchange and wether or not something could be
setup to run server-side.
 
Back
Top