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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unparsable Records 3
unparsable record 2
Importing .xls to Access data type problem 2
CSV Import Error 2
import csv truncation 1
Import errors importing Text into existing table, header vs no hea 3
Access Importing csv daily files into access 2007 1
Importing .csv files to Access 2003 database 2

Back
Top