MATLAB+Access insert函数应用问题 Variable fields and insert fields do not match.
英勇搬砖手 2018-03-05 11:17:48 准备编写一个程序,向数据库里添加信息,但是遇到了个错误,不知道是哪里出了问题,求大神指导,在线等
dlgTitle='填加产品相关信息';
lineNo=1;
prompt={'日期','冻鱼数量','冻鱼金额','乳品数量','乳品金额','鲜龙眼数量','鲜龙眼金额','香蕉数量','香蕉金额'};
def={'2000','10','1000','10','1000','10','1000','10','1000'};
answer=inputdlg(prompt,dlgTitle,lineNo,def);
%%
conna=database('Sheet1','','');
exdata=answer';
colnames={'日期','冻鱼数量','冻鱼金额','乳品数量','乳品金额','鲜龙眼数量','鲜龙眼金额','香蕉数量','香蕉金额'};
tablename='mainall';
insert(conna,tablename,colnames,table)
close(conna)
错误使用 database/fastinsert (line 111)
Variable fields and insert fields do not match.
出错 database/insert (line 37)
fastinsert(connect,tableName,fieldNames,data)
出错 Untitled2 (line 11)
insert(conna,tablename,colnames,table)