I currently have a DB that obtains its data from an Excel file. I have constructed a macro that when operated deletes existing datasheets and imports the new Excel data. It then constructs the new datasheets for Access.
I currently have this macro operated via a command button on my main form. However I wish for this macro to operate at midnight everyday. I have tried placing it in the 'onchange' event procedure for a text box containing '=date()', this however failed to work.
Any Suggestions?

You would use a form with a timer on it. Don't forget that the database will need to be left open in order for this to work. If you want the database to be closed, you will need a scheduling program that will open your database at the appropriate time and you will need an autoexec macro which runs on open.

The second method is the one my applications use. I have what I call a "batch" database separate from the interactive one my users use during the day. The scheduling program which runs on our server opens the access database at 3am and that activates the autoexec which runs our import, export, mail merge, and report printing functions.

Thanks Pat, could you possibly enlighten me on 'scheduling programs'.