Excel30万数据导入SQL server数据库

    public static void TransferData()
    {
        string sheetName = "a";  //
        string connectionString = "Data Source=.;Initial Catalog=Pujie;Integrated Security=True";//连接字符串
        DataTable dt = new DataTable();
        try
        {
            //获取全部数据  
            string strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=C:/Users/admin/Desktop/1.xlsx;Extended Properties=Excel 12.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            DataTable table = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string strExcel = string.Format("select * from [{0}$]", sheetName);

            OleDbDataAdapter myCommand = null;
            myCommand = new OleDbDataAdapter(strExcel, strConn);
            myCommand.Fill(dt);
            //用bcp导入数据  
            using (System.Data.SqlClient.SqlBulkCopy bcp = new System.Data.SqlClient.SqlBulkCopy(connectionString))
            {

                bcp.BatchSize = 1000;
                //datatable 列名-数据表列名
                bcp.ColumnMappings.Add("Material", "Material");
                bcp.ColumnMappings.Add("Description", "Description");
                bcp.ColumnMappings.Add("Division", "Division");
                bcp.ColumnMappings.Add("ProductHierarchy", "ProductHierarchy");
                bcp.ColumnMappings.Add("DealerNetAmount", "DealerNetAmount");  
                bcp.DestinationTableName = "ImportData";//目标表  
                bcp.WriteToServer(dt);
            }
        }
        catch (Exception ex)
        {
        }

    }