Schedule Data importing process

  • Thread starter Thread starter michael lam
  • Start date Start date
M

michael lam

Hi, I have a question on data uploading process.

In fact, on a daily basis, a csv file (same file name) is generated from a
data vendor and automaticallly put into a public folder. Then, the file
will be loaded into Access.

Currently, the loading process is done manually. Is it possible to schedule
the uploading process so that it can be done automatically behind the scene?

Thank you very much for your help!

Regards,
Michael
 
michael said:
Hi, I have a question on data uploading process.

In fact, on a daily basis, a csv file (same file name) is generated from a
data vendor and automaticallly put into a public folder. Then, the file
will be loaded into Access.

Currently, the loading process is done manually. Is it possible to schedule
the uploading process so that it can be done automatically behind the scene?

Thank you very much for your help!

Regards,
Michael
Click to expand...
In a form that opens at Startup, have the OnOpen event check to see if
the scheduled time has passed. If it has, execute the code to import
the file. If the time has not passed, set the form OnTimer event to
alarm when it reaches the time which is the difference between the
current time and the scheduled time. When the time alarms, do the import
logic.

In both cases, after you import the file, close the Form, this
way the form will only open and run once. If you have varous users, you
will need to add logic to tell the startup form that the import logic
has already run today. This way it will only execute once per day.

HTH,

Ron
 
Back
Top