public void BulkExceltoSQl(string Filename) { string sconExcel = @"Provider=Microsoft.ACE.OLEDB.12.0;Excel 12.0;Database=" + Filename + @";Extended Properties='HDR=Yes;'"; using (OleDbConnection connection = new OleDbConnection(sconExcel)) { OleDbCommand command = new OleDbCommand("Select DID, City, State From [Sheet1$]", connection); connection.Open(); using (OleDbDataReader dr = command.ExecuteReader()) { string sconSQl = Config.connectionString.ToString();
} }
}
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sconSQl)) { bulkCopy.DestinationTableName = "DID"; bulkCopy.WriteToServer(dr); }