Check for updated Files

[hewstone999]

When I open a form, I want it to automatically check to see if there is are any updated files. I already have imported files into Access, but want to automatically check to see weather there have been any updates to the files.

Example

Form opens,
Checks the “C:\MyDouments” for any updated Excel Spreadsheets (This could be done by the modify date and time),
Imports the updated Excel Spreadsheet into Access

End

If the code checks the Modify date and time of a excel file, how can I import these values into Access i.e. I could have some query that would check the date and time of an excel file against the date and time in the access table – and if different import the latest version.

Also check for any new files.


Any ideas or help would be much appreciated

 

[Guus2005]

Use the windows filesystemobject to retrieve the modified date of a file.