Excel rows sorted when imported to Access

[gwn]

I imported an Excel 2007 sheet with 53 rows into an Access 2007 db. I expected Access to read a row and write a row yet the order of the rows was changed. Does Access sort when importing and if so what are the rules and can they be controlled?
Thanks for your help

[boblarson]

Access doesn't store data in the tables in any meaningful order. You have to impose order by using a query. When you open the table your aren't really opening the table. You are opening a system query which shows you the data inside the table. So, you would need to have something that you can sort on to be able to then use a query and use the sorting to sort it when viewing/using it. You can use a query in 99% of the places you would use a table.