Auto-schedule Data loading process

[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

 

[Albert D.Kallal]

Sure, you can write a windows script, such as

dim accessApp

msgbox "Click ok to run batch job",64

set accessApp = createObject("Access.Application")

accessApp.OpenCurrentDataBase("C:\Documents and Settings\Albert\My
Documents\Access\ScriptExample\MultiSelect.mdb")

accessApp.Run "TimeUpDate"

accessApp.Quit

set accessApp = nothing

msgbox "Job complete", 64

You can type the above into a text file (note pad). Then, rename the
extension to .vbs. (note how the icon changes...you can now double click on
this icon to run the script). The above example will run a public sub called
TimeUpDate in a standard module. Of course, after you get your script
working, you would remove the msgbox commands. Then, you simply use the
windows scheduler to run the above script once a day.....

 

[michael lam]

Hi Albert,

Thank you very much for your help! Really appreciate it.

Regards,
Michael