excel拼接sql

excel怎么拼接sql

拼接insert语句，表名、字段、字段中文名为变化的，原语句如下：

INSERT
INTO
    DIS_VERIFY_CONFIG
    (
        RULE_IMP_ID,
        SS_ID,
        TEMPLATE_ID,
        COL_ID,
        RULE_ID,
        RULE_DES,
        PARA1,
        FILTER_SQL,
        REG_TYPE,
        ENABLE,
        PARA2,
        PARA3,
        RULE_GROUP_ID,
        COL_NAME,
        ERROR_LEVEL,
        PARA4,
        PARA5,
        TABS_VERIFY_FLAG,
        JS_CODE,
        VER_ID,
        TRACE_SQL,
        RULE_TYPE,
        VERIRY_TYPE,
        BUSINESS_TYPE,
        FILTER_JAVA
    )
    VALUES
    (
        'RULE_PBC2_P_DZYHT_P_MOTGA_PROPT_INF_KEY_ISNOTNULL',
        'PBC2',
        'PBC2_P_DZYHT',
        'P_MOTGA_PROPT_INF_KEY',
        'SQL_ISNOTNULL',
        '非空校验',
        NULL,
        NULL,
        '3',
        'Y',
        NULL,
        NULL,
        NULL,
        '抵押物信息',