Export to csv in sequence?

[wjl11]

I have a table that I sorted in zip code sequence. When I export the table to a csv file, it comes out in the original sequence (random). How do I export a file in the same sequence as the table view?

 

[sxschech]

Create a query that contains the sort order that you want and then instead of exporting the table, export the query.

Assuming you want all the fields, you can do something like this in SQL View...

Select * From Table Order By ZipCode;

You can also use the query grid in Design View and then choose Ascending in the Sort under the field you want to sort by.