Import Excel sort errors

[Patti]

I am having sorting errors when I try to import
spreadsheets from Excel into a new Access table A. When
I look at the resulting table A in Access it appears
correct. However when I copy that table A to a new table
B the records are disordered. I use a filter and resort
it correctly. It appears corrected, but when I make an
additional copy of the correctly sorted table B to yet a
third table C, the original resort error is there.

Anyone experienced this before. How do I correct it?

I am using Office 2002 products on XP.

TIA, Patti

 

[Ken Snell]

You don't "correct" sort "errors" in a table. A table has no "sort order".
Use a query that has an ORDER BY field or fields and let it sort your data.

 

[Ernie]

To expand on what Ken said, don't use copy / paste to copy
your table, use a make table query instead. The resulting
table will have whatever sort or filter criteria you apply
to the query. You can even use this to create a table in
another database.

 

[Ken Snell]

No, a table will not have any specific order. It may appear to have an
"order" when you open it in datasheet view, but you cannot depend upon that
"order" at any time. The only way to get a specific order is to use a query
for filtering/selecting the records.