Record order changes during import?

B

Barb

I am importing an Excel 2003 file (converted into a csv file) into Access
2003. The records are not importing in the same order as they exist in the
csv file. Why would this happen?
 
D

Douglas J. Steele

On what are you basing that observation?

The order of records in Access tables is, to some extent, random. The only
way to guarantee the order of records in a recordset is to use a query with
an appropriate ORDER BY clause.
 
B

Barb

Hmm...it has been my observation that usually records import in the order
they appeared on the original spreadsheet without any intervention. Thanks
for clarifying.
 
Top