Running a query automatically/automating query and exporting proce

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

Alex Dybenko

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
 
D

David C. Holley

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.
 

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

Exporting Query - Want count of records 5
Exporting multiple queries into Excel workbook tabs 10
Create an automated macro in Access which runs a query once a week 2
Error Exporting Access Query Results to Excel 1
Skipping queries to be exported 2
Export query result to Excel fails each week 1
Export to Excel 1
EXPORT EXCEL ROWS: CREATE ACCESS QUERY 1

Top