How to automatically import file to access

  • Thread starter Thread starter Jukka58
  • Start date Start date
J

Jukka58

Hello!

We have two computers and two programmers. One programmer for Ms Access 2000
and one programmer VB6 pro and applicartion.

Access database is large system and i not will transfer data to MDB
directly, it is second programmer work.

My VB6 program generates ASCII.TXT file, data to Access system.

But how access can read and trigger that new ASCII.TXT file is generated
from VB6 program?

Other words: Is access timer function (like VB)? Or how it observe that new
ascii.txt file is ready to read in to access database.

New file is generated automatically about 1 file per minute, from VB6
program. How access can observe it.
 
Yes, Access has a Timer feature similar to that in VB. In Access, there
isn't a Timer control, instead you put the code you want to run in the Timer
event procedure of a form. Use the form's TimerInterval property to
determine how often the Timer event will be fired.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top