Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access General > Im****ting Data...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 92549 of 97619
Post > Topic >>

Im****ting Data Error

by =?Utf-8?B?cGxvZGRpbmdnYWx0bg==?= <ploddinggaltn@[EMAIL PROTECTED] Aug 8, 2008 at 06:14 AM

I am im****ting 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 relation****p 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.
 




 4 Posts in Topic:
Importing Data Error
=?Utf-8?B?cGxvZGRpbmdnYWx  2008-08-08 06:14:01 
Re: Importing Data Error
"Allen Browne"   2008-08-08 21:50:12 
Re: Importing Data Error
Lynn Trapp <noltrapp@[  2008-08-08 08:53:42 
Re: Importing Data Error
Bob Quintal <rquintal@  2008-08-08 17:41:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Dec 4 21:54:18 CST 2008.