ACCESS批量插入

时间:2021-12-24 02:15:16

Insert INTO 目标表(id,供应商名称,供应商地址)
Select DISTINCTROW *
FROM (Select 1 AS ID,"天鸣1" AS 供应商名称,"广东中山" AS 供应商地址  FROM MSysObjects UNION
Select 2 AS ID,"天鸣2" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects UNION
Select 3 AS ID,"天鸣3" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects UNION
Select 4 AS ID,"天鸣4" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects)  AS tblTemp; 

Note: But the Row will be mutil when the inserting row only one. The repeat number will be reflect by the table MSysObjects.
Anybody know it‘s why?