Access automation (1 Viewer)

woknick

Registered User.
Local time
Today, 11:28
Joined
Sep 25, 2004
Messages
85
I would like to create a program within access that is linked to a specific folder on my C:\ drive and waits for a file to appear within the folder. Once the file appears, i would like access to process the file and return the output back to the folder. Is there a way to do this?

example: test.txt appears in folder C:\Test. Access grabs the txt file, opens it, processes the information and then writes the output back to C:\Test. I will need access to continously check the folder for new files.


thank you
 

KeithG

AWF VIP
Local time
Today, 11:28
Joined
Mar 23, 2006
Messages
2,592
Yes you could use the Timer event on a form. The form would have to remain open to check the directory for the file.
 

Users who are viewing this thread

Top Bottom