Access Export to Excel

[Bill]

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

Regards.
Bill.

 

[Dick Kusleika]

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

How are you exporting it?

 

[Shane Devenshire]

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.

 

[Bill]

How are you exporting it?

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.

 

[Bill]

Hi Shane,

I think your point 2 may be the cause.

Thanks.
Bill.