CREATE TABLE mytable
(
   /*id INT IDENTITY(1,1) PRIMARY KEY,*/
   Fname text,
   Surname text,
   Tel text,
   Salary DECIMAL(18,2)
);

 SqlConnection con =new SqlConnection(@"User id=sa;Password=oops;Server=VUYISWA\SQLEXPRESS;Database=Vuyiswa");
 
        SqlCommand cmdinsert = new SqlCommand();
 
        cmdinsert.CommandText=@"BULK INSERT mytable FROM 'C:\WebSite29\Data.txt' WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\n' );";
 
        cmdinsert.CommandTimeout = 0;
 
        cmdinsert.CommandType= CommandType.Text;
 
        cmdinsert.Connection = con;
 
        try
        {
            con.Open();
 
            cmdinsert.ExecuteNonQuery();
 
        }
        catch(SqlException ex)
        {
 
            Label1.Text = ex.Message.ToString();
        }   
        finally
        {
            if(con != null)
            {
                con.Close();
            }
        }