Help with export to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top