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
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