getting file attribues

[jimbuch920]

I want to import a tab delimited file (no date in the file) into a table no problem. After I have imported the file, I want to update a date field field in the table with the files creation or modified date/time.
Ex: The file might be created on 09-01-2013 but it would not be imported until 09-04-2013. So the date in the table should be 09-01-2013

[June7]

Add field to table and run an UPDATE sql action.

[jimbuch920]

I know update queries.. I guess I didn't make myself clear enough. I'll be using a form to import a tab delimited file which does not have any dates in it. After I import I'll run an update query to update the empty date field with the creation or modified date of the imput file. I don't want to use the 'Now()' in the update query since the input file may be created a few days prior. I really don't want to manually enter the date (manual intervention is subject to human error). Is the any code that I could use to get this date information from the file? Is this possible? This info is somewhere, all I need is retrieve it.

[June7]

There is a 'date edited' property of files but don't see how that will serve your needs. Unless the date is part of the file name or embedded somewhere in the text, I expect you (user) will have to provide the date.