Auto Export Query

A

AJOLSON

I would like have access import a file, then export a query based on that
file. However I would like that to happen automatically, based on a
recurring date and time. Say Every Monday Morning at 8:am.
Can anyone point me in the right direction?
I have the code to do it via a command button but I would like to automate
it. Thanks
 
A

Arvin Meyer [MVP]

Either use the Windows Task Scheduler (this is preferred) to open a database
front-end and accomplish the action, or leave a database open with the Timer
event set to run if it's Monday 8:AM.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a query based on a start date and end date. The date are the . 4
Automating export to Excel 4
Export to Excel 3
Auto Running a Query 1
Access Export to CSV 3
Export: use SendObject or Transfer? 2
Is it possible to Export a table to a EDI file? 10
Export to Excel + execute multiple query 1

Top