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

S

staylor74_

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
 
J

John Nurick

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.
 

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

Appending an existing table with imported Excel data 0
How to Append Table with file and add a field with file name 2
Importing Data and AUTONUM issues 1
Help with importing/appending 0
Import new data and replace old data in Access table. 2
Import errors importing Text into existing table, header vs no hea 3
Importing XML Data in Access 2003 1
Access import XML problems with append 0

Top