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.
 

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 Record 1
import csv conversion & import spec error 1
import csv truncation 1
Importing 2007 into 2003 3
Double quotes within text cause unparsable record error 2
Import fields from .csv with variable column structure 4
Import csv - unparseable record 2
Type Conversion Failure importing number as text 1

Top