[AccessD] OpenFileDialog multiselect order

[Ryan W]

Is there a way to control the MultiSelect order when selecting files?


Say we have files:

2-File.txt
3-File.txt
4-File.txt
5-File.txt
6-File.txt
7-File.txt
8-File.txt
9-File.txt
10-File.txt

If you click 2-File.txt and hold shift and select 10-File.txt, it selects
them all but then in the Filenames list below the file list, it shows the
order as 10-File.txt, 2-File.txt, 3-File.txt (etc).

So when the files get imported into the DB, 10-File.txt gets read in first
which changes the sequence of how we want the data imported.  Right now the
'workaround' is import 2-9, then come back and get 10+.

This is with Access 2013, though I don't think the version matters much.