access表里面用SQL插入记录

2025-01-01 12:40:58
推荐回答(3个)
回答1:

可以一次插入啊,用Select....Union可以一次插入多行数据insert 表名 (列名)
select "000003","kk","人事处",#2009/06/10#,null unionselect "000004","nn","教务处",#2009/06/10#,null

回答2:

insert into READER
values ("000003","kk","人事处",#2009/06/10#,null);
insert into READERvalues ("000004","nn","教务处",#2009/06/10#,null)

回答3:

一条一条的插入吧