Control Import File Seqence

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

Guest

I am trying to control the sequence of files which I import via a form using
the transfertext method. The files are selected at random and I want them to
be selected and imported in date sequence.
 
not clear how you get files list, which you import, but you can get any file
date using FileDateTime() function and then sort this list
 
I do get the file name and date, and then sort by date; however, the import
function does not select the earliest date, it seems to select at random.
 
Can you post your code here?

Alex

EdwardC said:
I do get the file name and date, and then sort by date; however, the import
function does not select the earliest date, it seems to select at random.
Click to expand...
 
Hi Edward,

This seems pointless, because once you get the records into a table they
lose any inherent order. Let them import as they will, and then use a
query to return them in whatever order you need.
 
Back
Top