Macro to automatically schedule append table

[kamitaken]

Hye Everyone,
I need some help here.
I would like to run an Append query that had been schedule automatically daily at a specific time .The Append query is designed to insert the newly inserted
records in TableA to TableB.
What do I need to do so the Append query is run in the schedule time as i try using task schedular but i not so familiar with it.

 

[RainLover]

Create a Database that when it opens it automatically runs some code. (Namely the append and or Update queries that you want.)

This can be called via an Autoexec Macro, or Open a Form on Startup that has the code in the Form Open event.

Make sure the last command is to quit the database.

Then you would need to create a Task in the Windows Task Scheduler.