AUTOMATE IMPORTS without pushing button

[Kye E]

Hello -

I need to automate the import of text (actually .dat) files from a Windows 2000 server intranet to an MS Access database. When I say "automate" I mean I need to have the import happen without human intervention, since this will be happening every 15 minutes, 24/7. I know how to import these using VB, but only with someone pressing a button on a form.

Thanks a billion!

 

[Kodo]

Make a windows service to do this

 

[namliam]

Or use the On Timer event...
Simply set it to 60 secs and check if the time is ... every 15 minutes, presto...

 

[Kye E]

Thanks!

Thanks ya'll!