Append to MS SQL 2005 table

  • Thread starter Thread starter MChrist
  • Start date Start date
M

MChrist

I'm getting a key violation error whenever I try and append records from a
table in Access to a table on a MS SQL 2005 database. The SQL db's table has
an IID field which is the primary key for the table (and the only indexed
field in the table) and I am NOT trying to append records to the IID field
with my INSERT INTO tImport(...) statement. It is a clustered index if that
makes any difference.

Since I can't seem to add the table and write to it without an index field,
does anyone have any ideas why I am getting the error message
 
Is the IID field an Identity/Autonumber type? If not, you will need to
generate some value that is unique for each of the records you want to append.
 
Duane,

As always, thanks for your response and your assistance.

In the many iterations before posting my question, I must of removed the
IDENTITY statement from my CREATE TABLE SQL.

Oops. Thanks again for your response.

Mark
 

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

Action Query (Append) didn't add records due to key violations. 5
Access 2010 append query to SQL is very slow 0
Using Append Queries with Linked Tables 3
Key violations on Append query - no indexes on table 8
Figuring out what field is causing key violation on append 6
Access 2002 Append Query Problems 1
Append Query To Table 3
Append Query - Key violation 1

Back
Top