insert into nct_parcelcollect (parcelcollectID,cantoncode,cantonName,sumarea,year) values(1,'1','1',2008,,23.23)
直接在access是没有问题的,
在C#中,insert into nct_parcelcollect (parcelcollectID,cantoncode,cantonName,sumarea,year) values(1,'1','1',2008,,23.23)是有问题,提示无法错误
原因在于:year是access的关键字
修改为
insert into nct_parcelcollect (parcelcollectID,cantoncode,cantonName,sumarea,[year]) values(1,'1','1',2008,,23.23)
就可以了