Import append issue (Excel to Access table); data transposition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several Excel files (each ~30000 records) that I am importing to one
Access table in Office 2002. The initial Excel file imports without
difficulty, but as the second file appends to the table there is a
transposition of around 400 records within the second table (i.e. Access
physically shifts the records to an incorrect location in the table). Any
idea why this is happening?

S Taylor
NCSU
 
Tables in relational databases such as Access don't have any inherent
order and cannot be relied on to maintain the order in which records
appeared in the source data. If you want to see the records in a
particular order you have to use a query to sort them on one or more
fields.
 
Back
Top