View Full Version : Run query same time every day


dhl123
07-07-2008, 03:06 AM
Hi,

Have created query and would like to run it every day at the same time. Also query results should be written to excel file.

Should I use Windows Scheduler or VB?

Br, Miikka

namliam
07-07-2008, 04:01 AM
Both I guess. You need the scheduler to trigger the time then have VBA to export your data.

namliam
07-07-2008, 04:12 AM
Both I guess. You need the scheduler to trigger the time then have VBA to export your data.