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?

Twyce!

Well the simple answer is to either not import records that violate the primary key, or remove or hane the primary key.

You haven't told us what the table looks like, nor what the primary key is so we couldn't tell you more.

/- Sam Judson : Wrox Technical Editor -/