Automate Importing Data via ODBC

[Lee T.]

My client wishes to copy data from SQL Server to the local
ACCESS backend database. They want this done every night
at 3AM automatically. I can set up the ODBC link and all
but have no idea how to get it to run automatically.

tia

Lee T.

 

[Guest]

If you're on XP, there is a "Scheduled Tasks" application
in the control panel that allows timed scheduling. It will
only be able to start your Access db, but if you create a
macro that performs all the functions you need and name
the macro, "Autoexec" when the Scheduled Tasks program
starts your database, the macro will start automatically.>-
----Original Message-----