export as text

[Guest]

I have a text file with 500,000 numbers in it on different lines
I need it sorted in ascending order.
I imported into a clean database making a table with 1 field an no index.
Then I sorted the table in ascending order, proved it by opening the table
and checking, no problems so far
I then run a "compact database" from the tools menu.
When I went to export the table as a text file, it put all the numbers back
into the order that they were imported in, not in the ascending order as in
the table.
Is there any way to get access to export data in the ascending order

 

[tina]

create a query, sorting the field Ascending in the query. then export the
query.

hth