Access Export to Excel

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Anyone any idea why correctly sorted data in an Access Query that is
exported to Excel appears in a different order?

Regards.
Bill.
 
Hi,

I can't duplicate your problem, using Office Links, Anlayze with Microsoft
Office Excel, nor if I choose File, Export and send the query to an Excel
file. Check in Access to make sure your data is sorted in the query output
as you think it is.

Remember, if your Access table is sorted, the query does NOT use that sort
order unless 1. You tell the query to, or 2. That sort order is the Primary
Key sort order of the underlying table.
 
Dick Kusleika said:
How are you exporting it?
Click to expand...
I have memo fields in the export so have to deal with that bug too.

I select the query, then choose File-Export then a file type of Excel
97-2003.

The Access query is in fact in its natural order, which is fine. The query
simply groups data from three tables. But in Excel a number field a few
columns in seems to randomly get out of order.

Thanks for the reply.

Bill.
 
Back
Top