Automating MSAccess process

[Doug]

I want to import and export files from an MSAccess
database at certian times and days of the week. I know
how to do this for replication and synchronization using
Replication Manager but need to do this for TransferText
and TransferSpreadsheet actions.

Doug

 

[SA]

Doug:

Write a function in your db that runs the process you need to automate.
Then using the Windows Scripting Host, write a vb or java script that
launches Access and uses the Run function of the Application object to call
your internal function. Lastly use the Windows Task Scheduler to launch
cscript.exe and the target script. If you need some samples, stop by our
web and look in the Code and Design tips area under both reports and the
general section to see some scripts that are used to run reports and/or
compact a db on a schedule.