In Access 2002, how to find the names of recently imported files?

[Guest]

I have imported some csv files into some tables in my Access database. I want
to find out the names of those files, where can I look? The reason I want to
know is that I have similar looking files and am not sure which one I
imported into existing tables. For eg: Mar06 and Mar06v2 are both csv files
and I just want to know which one I had imported and on what date. Please
help me if yuo can. Thank You. Nilesh.

 

[John Nurick]

Hi Nilesh,

Access does not by default keep records of things like which files you
imported and when.

If you are using Windows 2000 or XP, you may get some useful information
by checking the Last Accessed dates of the files (e.g. by using
DIR /TA
at a Windows command prompt. But if done anything with the files
yourself since importing them the Last Accessed dates will have been
changed acordingly.

Another approach would be to create a linked table connected to one of
the text files, and then use a Find Unmatched query to identify records
in the linked table that do not have counterparts in the main table. If
all of the records have counterparts, the text file either has been
imported or is a duplicate.