我的实现方式是利用NPOI将Excel表格读取到Datatable
根据需要调整Datatable的表结构
创建数据库临时表
利用SqlBulk将Datatable中的数据导入到临时表中
利用数据库中存储的预处理语句对临时表进行处理
将处理后的数据insert到数据库正式表中

目前遇到的问题
1、利用NPOI读取效率并不高，但能够满足需要
2、导入数据时，有时快，有时慢出现超时提醒
3、每次导入的数据1万条以内

代码如下：

        using (SqlConnection con = new SqlConnection(Variables.SysConStr))
        {
            con.Open();
            using (SqlTransaction tran = con.BeginTransaction())
            {
                try
                {
                        DataTable originalTable = ExcelImportExport.ImportExcel(filename, false, -1, 0, true, 24, fileBh);//读取原始数据保存到表




                            tempTableName = SystemMethods.CreateTempTable(tran, originalTable);
                            SystemMethods.ImportDataToTemp(tran,originalTable, tempTableName);
                            SystemMethods.ProcessData(tran, tempTableName, SjLy); 


                    }
                    tran.Commit();
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                   
                }
                finally
                {
                    if (con.State == ConnectionState.Open)
                        con.Close();
                }
            }
        }




    public static string CreateTempTable(SqlTransaction tran,DataTable dt)
    {
        string TableName = SqlServerHelper.ExecuteScalar(tran, "SELECT '#'+CAST(NEWID() AS NVARCHAR(40)) AS TableName", null).ToString();
        TableName = TableName.Replace("-", "_");
        //获取创建表的SQL 
        string sqlStr = "Create table " + TableName + " ( ";
        foreach (DataColumn dc in dt.Columns)   //循环列 
        {
            //获取创建表的SQL,具体自己再发挥 
            sqlStr = sqlStr + "[" + dc.ColumnName + "] nvarchar(200), ";
        }
        sqlStr = sqlStr.Substring(0, sqlStr.Length - 2) + ") ";
        SqlServerHelper.ExecuteNonQuery(tran, sqlStr, null);
        return TableName;
    }

    public static void ImportDataToTemp(SqlTransaction tran, DataTable dt, string TempTableName)
    {
        using (SqlBulkCopy bcp = new SqlBulkCopy(tran.Connection, SqlBulkCopyOptions.Default, tran))
        {
            bcp.DestinationTableName = TempTableName;
            bcp.WriteToServer(dt);
        }
    }

    public static void ProcessData(SqlTransaction tran,string TempTableName,string BankName)
    {
        string sqlStr = "SELECT FLEVEL,FVALUE FROM SystemProfile WHERE FCATEGORY='数据导入' AND FKEY='预处理' AND FTYPE='" + BankName + "' ORDER BY FLEVEL";
        DataTable dt = SqlServerHelper.ExecuteDataSet(tran, sqlStr, null).Tables["Table1"];

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            sqlStr = dt.Rows[i]["FVALUE"].ToString();
            sqlStr = sqlStr.Replace("#TEMP#", TempTableName);
            SqlServerHelper.ExecuteNonQuery(tran, sqlStr, null);
            System.Threading.Thread.Sleep(200);
        }

        sqlStr = "DROP TABLE " + TempTableName;
        SqlServerHelper.ExecuteNonQuery(tran, sqlStr, null);

    }