S1 : 创建一个模板表 create table t (id int, col1 int , col2 varchar(10)); S2 : EXCEL中在A1输入 ="create table t"&ROW()&" like t;" S3: 下拉填充这个A1至A1000 create table t1 like t; create table t2 like t; create table t3 like t; create table t4 like t; create table t5 like t; create table t6 like t; create table t7 like t; create table t8 like t; create table t9 like t; create table t10 like t;