Help with export to excel

A

Al

I am working in Access 97. I am trying to export 4 fields to excel. How can I
keep them in the same order/sorting they are in, in access. the order and
sorting keeps getting messed up every time I export to excel. The number of
records is usually 30 to 50 rows.
thanks
Al
 
D

Douglas J. Steele

The only way to be sure is to create a query that sorts them in the correct
order, and export the query, not the table.

You should never assume anything about the order of records in tables.
 
Top