| B | C | D | E | |
| TABLE1 | 入力内容 | insert into TABLE1 values( | ||
| 項目１ | ITEM１ | CHAR | UT001 | ‘UT001‘, |
| 項目２ | ITEM２ | NUMBER | 2 | 2, |
| 項目３ | ITEM３ | VARCHAR | 1675186196 | ‘1675186196‘, |
="insert into "&B8&" values("
=IF(ISERROR(SEARCH("NUM",D9)),IF(ISERROR(SEARCH("DATE",D9)),"‘"&E9&"‘,","to_date("&"‘"&E9&"‘,‘yyyy-mm-dd hh24:mi:ss‘"&"),"),IF(E9="","null,",E9&","))
=IF(ISERROR(SEARCH("NUM",D10)),IF(ISERROR(SEARCH("DATE",D10)),"‘"&E10&"‘,","to_date("&"‘"&E10&"‘,‘yyyy-mm-dd hh24:mi:ss‘"&"),"),IF(E10="","null,",E10&","))
=IF(ISERROR(SEARCH("NUM",D11)),IF(ISERROR(SEARCH("DATE",D11)),"‘"&E11&"‘,","to_date("&"‘"&E11&"‘,‘yyyy-mm-dd hh24:mi:ss‘"&"),"),IF(E11="","null,",E11&","))
原文：http://www.cnblogs.com/taobr/p/4377653.html