RE: identifying, copying, and renaming the newest CSV file for import

Tech-Archive recommends: Fix windows errors by optimizing your registry

The file I want is:

"11_29_05_1030AM_DMS.csv"

The file I don't want is:

"11_29_05_1030AM_DMS_Meth_Full.csv"

Every hour new files are added to the directory. It might be preferable to
use the latest modified dates rather than the filenames. What say you?

I just posted a new thread, "Code doesn't find newly imported data in a
table", that's related to this module as well. Any suggestions there would be
deeply appreciated. After importing the CSV contents, the data doesn't seem
to be readable in subsequent code.

Thanks,

"Gort"

"Barada nikto"

Klatuu wrote:
>This is doable. To give you a complete answer, I need to know what the
>naming convention of the .csv files is and how you know which is the one you
>want. In the mean time, go into VB Help, select the Object Browser, and read
>up on the FileSearch object.
>
>> Every hour, 2 CSV files, with a naming convention reflecting the date and
>> time of their creation, are added to a directory on a server. I can easily
>[quoted text clipped - 12 lines]
>>
>> Bill

--
Message posted via http://www.accessmonster.com
.