Write modified date of imported file into the table?

[Bdog05]

I am trying to setup a process whereby a text file is imported into a table daily. It would simplify my life greatly to be able to write either the filename, or the file's last modified date, into a seperate column in the table and associated with each row of data imported for the particular days file.

Anyone have any ideas how I can do this?

Thanks much for any help that can be provided.

 

[TonyGroves]

You would have to use a script to compose and run a separate query to update the file-data field:
[tt]
UPDATE tblname
SET filedata='$filedata'
WHERE filedata IS NULL;
[/tt]

 

[ericbrunson]

Or you could put that data in the file when it is generated.