Text File - Capturing import Date/Time

[Kirk P.]

I have a macro that imports several tab delimited text files into various
tables. I would like to capture the date/time of the import in these tables.
Any good way to do this?

 

[John Nurick]

Hi Kirk,

Here's one way. I assume you have a date/time field in the tables
already; I'll call it DateImported.

For each table, create an update query that updates DateImported to
Now() where DateImported Is Null.

Then have your macro run the appropriate query after each import.

 

[Kirk P.]

Thanks, that is a simple solution that works perfectly!