Import newest created text file only

[plucnik]

Wasn't able to find this addressed in search although I'm sure this question has been raised before. We have a software program that automatically creates a daily text file. Each daily file is uniquely named so I have an archive of these files in a folder. I want to import the file that was created yesterday and ignore the rest using transfertext. Appreciate any help.........thanks

 

[Robert88]

Hi plucnik,

You could always consider reading in all files with http://www.access-programmers.co.uk/forums/showthread.php?t=101435

Once you have them all in a table you could include date and time info and then sort to get the latest in a query which would give you the latest file, assuming no others of later date are present?

Robert88

 

[plucnik]

Thanks for the suggestion. That may be the way I have to approach this. I thought I saw a solution to this at one time but Alzheimer’s is kicking in.......

 

[Robert88]

Hi plucnik,

Sounds like you have to throw out your aluminium frypans/saucepans. Theory has it, it helps Alzheimer’s.

Who said getting old was easy, You make me feel young. And glad to have helped.

Robert88