Schedule query

[mikeraut]

I have a MS Access database that I have written a query for.
I would like to produce a MS Excel file on a daily basis. The process is manual at the moment and I would like to know if this process can be automated without incurring the cost of a 3rd party applicatio?

 

[mikeraut]

Sorry guys and girls - Incorrec forum!

 

[Triacona]

Hi,
I know this is not a MS forum, but here is a quick answer.
You could use MS Windows task scheduler to run the Access Database.
And within the Access Database run a Macro, so that when Task Scheduler runs the Access Database the Macro runs with the following commands:
Open query
and Export to Excel.

Hope this helps?
Kind regards
Triacona