Control Import File Seqence

[EdwardC]

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.

 

[Alex Dybenko]

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

 

[EdwardC]

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.

 

[Alex Dybenko]

Can you post your code here?

Alex

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.

 

[John Nurick]

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.