Please help me why this error comes with my code
Datatype Mismatch error
my sql querry is
strdml="INSERT INTO Id (Id,orderdate,type,comm,disc,consigneename,lcno,ld ate,lamount,expdate,buyerorderno,buyerorderdate,bc urrency,remarks,commagent,style,model,deldate,unit )values('"&Id&"' , '"&orderdate&"' , '"&otype&"' , '"&comm&"' , '"&disc&"' , '"&consigneename&"' , '"&lcno&"' , '"&ldate&"' , '"&lamount&"' , '"&expdate&"' , '"&buyerorderno&"' , '"&buyerorderdate&"' , '"&bcurrency&"' , '"&remarks&"' , '"&commagent&"' , '"&style&"' , '"&model&"' , '"&deldate&"' , '"&unit&"')"
Please tell me the reason
Thank u