insert {TDepart_Roles} ([DepartID],[RoleID],[Remark],[CreaterID],[CreateTime]) Values('"& DID &"','"& RID &"','"& STR &"','"& CurrentUserID &"','"& date.today() &"')"
语句有问题。语法应该为,你没加INTO
Insert into Table2(a, c, d) select a,c,5 from Table1
INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees')
试试这个
insert into {TDepart_Roles} ([DepartID],[RoleID],[Remark],[CreaterID],[CreateTime]) Values('"& DID &"','"& RID &"','"& STR &"','"& CurrentUserID &"','"& date.today() &"')"