Export to excel and keep the same order as in access

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

Guest

When I export to excel from Access 2003 I receive the records in Excel in a
different order then it was in access How do I maintain Order ???
 
Hi Nach,

An Access table is in effect a "bucket" of data with no inherent order.
Any time you want to be sure you'll see it in a particular order you
need to create a query that explicitly sorts it.

So for exporting: if the order matters, create a query that returns the
data the way you want it, and then export the query.
 
Back
Top