Can access read file date?

[mike_davis]

I want to import a text file, but only if the file has been updated. Can
Access 2002 read a file date?

 

[Ken Snell [MVP]]

Check out the FileDateTime function in VBA Help.

 

[Rob]

I have a database that does something similar to what yo
uare asking.

I have txt files that are FTP'd to a folder using a static
name (Monday's file = monstat.txt, etc.).

When my DB opens, it automatically opens a form that
checks for those files. Using unbound fields, I set their
Control Source as follows:
=FileDateTime("G:\CPR BRANCH\Access Project 2001
\Stats\ftp\monstat.txt")

I then added some other fields to help identify one file
from the next (file size) using a similar method:
Control Source as follows:
=FileLen("G:\CPR BRANCH\Access Project 2001
\Stats\ftp\monstat.txt") & " Kilobytes"

I then have check boxes next to the unbound fields that
the user 'checks' to import the file. A macro then reads
the status of the check boxes and imports the files that
were 'checked' for import.

You can do the same thing for non-static file names by
using other unbound forms to enter the file path and name,
then having the macro read those fields to import the file.