Sort sequence changes

[Lois]

I have sorted my records in Access 2002 the way I would like them to be
exported into a fixed format txt file. Why are the records resorting in the
exported file? They lose their sort from the Access table.
thanks in advance for any help.

 

[Andi Mayer]

I have sorted my records in Access 2002 the way I would like them to be
exported into a fixed format txt file. Why are the records resorting in the
exported file? They lose their sort from the Access table.
thanks in advance for any help.

there is no Order in a table

use a query like: "SELECT * FROM MyTable ORDER BY MyField"