Auto Import from a folder when a file is placed into the folder. Access 2007 append data

Hi All,

I have created an Access database with a table with all the required fields. We have a database called Navision which exports TXT files to a shared folder. At the moment we have to manually import them from this shared folder to the Access Database and then append the data.

What we need is when Navision exports this to a folder it automatically imports into access database so we need a folder monitoring system or is there an access script we can run?

Any Ideas would be great.

Cheers

AdamStart Free Trial