Import files out of order

[Queryman]

I'm running a macro that imports text files into a table. I do a "delete"
query on the table to clear the contents and then I start import text file1,
text file2, etc...

The problem I have is that sometimes the text files are not in the table in
the I imported them. Sometimes text file3 is before text file2 even though
my macro has the import of text file2 before text file3.

Any ideas - apprciated.

 

[Steve Schapel]

Queryman,

Data in a table has no inherent order whatsoever. The only way to
control the order of data is with a query, Queryman. If you want the
order to be based on the file the data was imported from, you will need
to include a field with a reference to the text file in the table you
are importing into, and use this in your sorting.