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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting table to Excel, columns moved 2
Exporting table containing dates 6
How to Export Gmail Emails to PST Format? 4
Export to excel with pictures????? 1
Find fields that will truncate importing from Excel to Access 4
Exporting pivot tables 2
Export records in order 4
Override Access's Current Internal Choices 4

Back
Top