protected void Button1_Click(object sender, EventArgs e) 
    {             // Connection String to Excel Workbook 
        string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\property.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; 
 
        // Create Connection to Excel Workbook 
        using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(excelConnectionString)) 
        { 
            System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(" Select CountyCode,PropertyAppraiserName FROM [county$]", connection); 
 
            connection.Open(); 
 
            // Create DbDataReader to Data Worksheet 
            using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) 
            { 
                // SQL Server Connection String 
                string sqlConnectionString = @"Data Source=myServer;Initial Catalog=mytest1;Integrated Security=True"; 
 
                // Bulk Copy to SQL Server 
                using (System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(sqlConnectionString)) 
                { 
                    
                    bulkCopy.DestinationTableName = "dbo.PropertyAppraiser"; 
 
 
                    //Define ColumnMappings: source –--destination  
 
                    bulkCopy.ColumnMappings.Add("CountyCode", "DesCountyCode"); 
                    bulkCopy.ColumnMappings.Add("PropertyAppraiserName", "DesPropertyAppraiserName"); 
                   
 
 
                    DataTable mydt = new DataTable(); 
 
                    mydt.Load(dr); 
 
                    IEnumerable<DataRow> RowsSkip5 = mydt.AsEnumerable().Skip(5); 
 
 
 
                    bulkCopy.WriteToServer(RowsSkip5.ToArray()); 
 
                    //bulkCopy.WriteToServer(dr); 
 
 
                } 
            } 
        } 
    }