Keeping sort order when exporting to .txt

[Mark Parent]

I've got data in a table, and sorted it using a filter.
It looks fine on the screen. When I try to export this
table to a .txt file, the data appears resorted.

How can I keep the sort order when I export ?

 

[ELanier]

One method is to create a query with the fields and sort order you desire. Then export the query instead of the table.

 

[Douglas J. Steele]

Actually, that's the only reliable method.

You should never assume anything about the order of records in a table. If
the order is important, the only sure way is to use a query with the
appropriate ORDER BY clause.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

One method is to create a query with the fields and sort order you desire.

Then export the query instead of the table.

 

[Guest]

That's working fine. Many Thanks !

-----Original Message-----
Actually, that's the only reliable method.

You should never assume anything about the order of records in a table. If
the order is important, the only sure way is to use a query with the
appropriate ORDER BY clause.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)




(e-mail address removed)... sort order you desire.
Then export the query instead of the table.


.