Export to excel and keep the same order as in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nach - 22 Nov 2004 20:35 GMT

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 ???

Reply to this Message

John Nurick - 23 Nov 2004 05:15 GMT

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.

>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 ???

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message