By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Scheduled - Access Export to update an Existing Excel File

P: 17
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
Dec 10 '07 #1
Share this Question
Share on Google+
1 Reply


BradHodge
Expert 100+
P: 166
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.
Dec 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.