Importing Data Error

[ploddinggaltn]

I am importing txt data into an existing table with no primary key. I get an
error saying:

“Microsoft Office Access was unable to append all the data to the table.

The contents of fields in 0 records were deleted and 87 records were lost
due to key violations.

*if records were lost, either the records you pasted contain primary key
values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.â€

My trouble is there are no existing records in the table I’m appending so
the primary key values don’t already exist and the table is not linked to any
other tables. Any help you can give me is greatly appreciated. Thank you.

 

[Allen Browne]

There are many things that can cause an import to fail.

For a check list, see:
Why can't I append some records?
at:
http://allenbrowne.com/casu-19.html

 

[Lynn Trapp]

I am importing txt data into an existing table with no primary key. I get an
error saying:

“Microsoft Office Access was unable to append all the data to the table.

The contents of fields in 0 records were deleted and 87 records were lost
due to key violations.

*if records were lost, either the records you pasted contain primary key
values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.”

My trouble is there are no existing records in the table I’m appending so
the primary key values don’t already exist and the table is not linked to any
other tables. Any help you can give me is greatly appreciated. Thank you.

Do you have some other unique index set on the table?

Lynn Trapp
www.ltcomputerdesigns.com