I have the following code that gets a list of files to import. <pre>FName = Dir(importPath & "PO*.csv")
Do While FName <> ""
ImportData = True
FileList(i) = FName
'move to the next file in the list
FName = Dir
i = i + 1
TotFiles = i</pre>
Then that array is run through and the files are imported into my database.
Is it possible to control the order they are loaded to the array? I NEED to process the oldest file first.