Scheduled - Access Export to update an Existing Excel File

[egrill]

I have an Excel file that needs to be updated nightly and sent to a user. I can't find anyway using the existing marcos that would allow me to set a automated command to run the query on a scheduled time (12:00 am) and update the Excel file and send to the user.

Anybody have any ideas?

Thanks

[BradHodge]

I have an Excel file that needs to be updated nightly and sent to a user. I can't find anyway using the existing marcos that would allow me to set a automated command to run the query on a scheduled time (12:00 am) and update the Excel file and send to the user.

Anybody have any ideas?

Thanks

You could use Windows Scheduled Tasks to open the application. If your AutoExec was set to run the Append query, that would likely get the job done.

Brad.