I'm doing it now on a weekly basis starting monday (hope it works)...
..
I use windows scheduler to run an empty MS-Database that does nothing but
use this VBA
command at start up time, then of course closes...
(it uses an import spec already prepared)
DoCmd.TransferText acImportFixed, ".\FPHistData.mdb.FlatFileHistory
Import Specification", ".\tblFPHistory",
"N:\PUBLIC\FPHist\DOWNLOAD\TEMP.TXT"
"Skynet" <tim1 (AT) skynet (DOT) be> wrote
Quote:
Hi,
I want to update some fields in my database automaticly for every hour but
I
have no idee how to do it.
Maybe with a script? The programme must keep running as long as my
computer
is on. Can somebody help me or know where to find information?
Thx
Tim |