Record order changes during import?

  • Thread starter Thread starter Barb
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top