Keeping sort order when exporting to .txt

  • Thread starter Thread starter Mark Parent
  • Start date Start date
M

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 ?
 
One method is to create a query with the fields and sort order you desire. Then export the query instead of the table.
 
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)



ELanier said:
One method is to create a query with the fields and sort order you desire.
Click to expand...
Then export the query instead of the table.
 
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.


.
Click to expand...
 
Back
Top