C#

Driver={MySQL ODBC 5.2 Driver};Server=[server url];Port=3306;Database=[dbname];User=[usrname];Password=[pwd];Option=3;

(Provider=MySQL Provider;Data Source=[servername];User ID=[usrname];Password=[pwd];Initial Catalog=[dbname];) The driver is "activated".

Hello, 
 
I have imported a CSV file into SQL, the wizard has added this as a new table. 
 
I am trying to run a SQL Statement to insert the data from the imported table into the one I need to use in the new data table. 
 
However I am getting the following error. 
 
 Collapse | Copy Code
Msg 2627, Level 14, State 1, Line 4
Violation of PRIMARY KEY constraint 'PK_Customer'. Cannot insert duplicate key in object 'dbo.Customer'. The duplicate key value is (105).
The statement has been terminated.
 
This is my statement: 
 
 Collapse | Copy Code
INSERT INTO dbo.Customer
(custID,lastName,firstName,title,address1,address2,address3,postCode,email,fax)
SELECT ACCOUNT,SURNAME,FORENAMES,TITLE,ADD1,ADD2,ADD3,POSTCODE,EMAIL,FAX
FROM dbo.[NCCUST CSV FORMAT PFS 9.1.14];
 
Any pointers would be great Smile | :) 
 
Thanks