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

protected void btnAdd_Client(object sender, System.EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=JOHN-PC\SQLEXPRESS;Initial Catalog=subiect1;Integrated Security=True");
            try
            {
                con.Open();
                SqlCommand command = new SqlCommand("SET IDENTITY_INSERT Clienti ON");
                command.ExecuteNonQuery();
                SqlCommand cmd = new SqlCommand("insert into Clienti(ID, Nume, Prenume, Data_Nasterii, Adresa_mail) values(@ID, <a href="/Members/nume">@Nume</a> @Prenume, @Data_Nasterii, @Adresa_mail)", con);
                cmd.Parameters.AddWithValue("@ID", txtID.Text);
                cmd.Parameters.AddWithValue("@Nume", txtNume.Text);
                cmd.Parameters.AddWithValue("@Prenume", txtPrenume.Text);
                cmd.Parameters.AddWithValue("@Data_Nasterii", txtDataNastere.Text);
                cmd.Parameters.AddWithValue("@Adresa_mail", txtAdresamail.Text);

                int count = cmd.ExecuteNonQuery();
                if (count == 1)
                    lblMsg.Text = "Clientul [" + txtID.Text + "] a fost adaugat!";
                else
                    lblMsg.Text = "Clientul nu a putut fi adaugat!";
            }
            catch (Exception ex)
            {
                lblMsg.Text = "Error --> " + ex.Message;
            }
            finally
            {
                SqlCommand command = new SqlCommand("SET IDENTITY_INSERT Clienti OFF");
                command.ExecuteNonQuery();
                con.Close();
            }
        }