Export data at the end of every month automagicly

[Perceptus]

I would like to export the data from a query at the end of every month. I have thought of making a powershell script to do this and having it set as a scheduled task. Are there any better ways to achieve this? I would prefer the task to be run automagicly.

[pbaldy]

Probably whatever tool you're comfortable with. I'd probably create a little Access db that ran the export upon startup and then closed, and run that from Windows Scheduled Tasks. If you go that way, I and many others have run into the problem of an accdb not running from there, but an mdb will.

[Perceptus]

I have created an access database to use an autoexec macro like you mentioned PBaldy. It works great on windows XP but gives me a critical error about "There was a problem sending the comand to the program" on windows 7. The file appears to export fine for both OS's, regardless of the error message.

[pbaldy]

Curious. Is there something after the export that could cause the error?

[rpeare]

If your database is opened every day (or close to it) can you not have a table that tracks the last export date, and if the current date is greater than the expected 'next' date the export is performed? Then update the 'tracking' table with the new most recent export date.

You wouldn't need an autoexec macro if you did this, just something in the on load or on open event of your main form.

[Perceptus]

After the export I have an entry for Quit (Exit).

The database is generally just left open on most users desktops. I want to say when people go home they just leave their front ends open.

I will be running the database export this evening, thanks to all the ideas and comments.