Text File - Capturing import Date/Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top