access创建一个表格根据另一个表

select   * into zd from  xzdm 

 

select   * into zd from  xzdm  in "C:\征转处\TJSoft\TJSoft\bin\Debug\data\ss.mdb"

sql = string.Format("insert into {0} select * from {1} in '{2}' " +
"where (code='{3}' and YM='{4}')", TabList[j] + "1", TabList[j],
mdbpath + YM + "_" + myCode + ".mdb", myCode, YM);

pAccessOP.ExecuteNonQuery(sql);