Automate Importing Data via ODBC

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

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.
 
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-----
 
Back
Top