AUTOMATE IMPORTS without pushing button (1 Viewer)

K

Kye E

Guest

• Jan 22, 2006

• #1

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

"The Shoe"

Local time

Today, 13:59

Joined

Jan 20, 2004

Messages

707

• Jan 22, 2006

• #2

Make a windows service to do this

 

N

namliam

The Mailman - AWF VIP

Local time

Today, 19:59

Joined

Aug 11, 2003

Messages

11,695

• Jan 23, 2006

• #3

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

 

K

Kye E

Guest

• Feb 5, 2006

• #4

Thanks!

Thanks ya'll!