Loading

Violation of PRIMARY KEY constraint????

Zimbini Walaza

I am using bulkcopy to import data into SQL server database.The data i'm trying to import contains student numbers and the modules that they are registerd for.A student can be registered for many modules(which means one student number can appear many times on the table).Problem is when i try to import my spradsheet my application throws a "Violation of PRIMARY KEY constraint" error.
How do i fix this

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ryan Alford18y ago
since you didn't give much information on the table layout, all I can tell you is to make sure that you don't have duplicate student numbers in the spreadsheet. that is what the error is saying.
+1