Scheduling import from AS400

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

We are attempting to set up daily download schedules
(same time every day)from our IBM AS400 to an access
database. Is this possible, How? Thanks for any info
 
Sure it is possible.
Use a scheduling program to kick off Access.

You can use a scheduling program like Arcana, SKEDEZY Or Launchpad to kick
off any executable at any time. Sometimes the built in scheduler actually
works too. (The AT scheduler in NT fails with linked ODBC tables though!)

You simply use a command line like:
"C:\Program Files\Office10\MSaccess.exe" "C:\mydocs\mydata.mdb" /x
"MacroName"

The Macro Name can call Runcode so you can execute just about anything you
can think of.
The last part of the macro should be Quit to exit Access.
 
Back
Top