Access Data in Excel - Sorting

[bonnepoutine]

I have some data in an Access Table that I have imported to an excel file.



The problem is that even though I have sorted the data in Access in alphabetical order, every time I refresh it in the Excel file it sorts itself back into the order it was created instead of sorting in Alphabetic order.

Is there any way around this?

[pbaldy]

Once it's in Excel you'd have to use Excel sorting. If you mean when you populate Excel, I'd try importing a query that had the desired sorting.