Delimted text export writes random order?

[captnk]

I have been experimenting with exporting,delimited text files.
I have noted that despite the fact the originating table is sorted in "date descending order",the resulting delimited text file appears in a random format (not in same date order),although it keeps groups of items (in this case location) together.

Does anyone know what criteria Access applies when deciding the write order,or how to define the write order.
Its not critically important,but the random order does make it annoying if u want to look up something in date order in the text file

 

[captnk]

Tks Pat
I have read yr previous posts under unordered sets.
Finding posts is easy when u know the search criteria text

Looks like it is a Relational db convention
Unfortunately I cant have a number field or an index as this would effect the programmes that import the delimited files.
At this point its not such a problem that its worth spending a lot of time on.

Although I will look at using a query as the delimited text source
Captnk

 

[Mile-O]

You may want to to look at The Doc Man's explanation on this thread.