syntax error in insert into statement in vba

Hi

i got a error while insert a data. if same query i run in ms access its working row append.

but code through means its show error. pls help us.

Coding

Public db As New ADODB.Connection
.....
.....

vquery1 = "INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('" & VPROD & "','" & VTYPE & "','" & VMONTH & "','" & VAGEINGBRACKET & "','" & VOCREF & "','" & VPARTYNAME & "'," & VINVQTY & "," & vpassvalue & ")"

db.Execute vquery1

query with values:

INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('AV','1.BOOKED','2011 10 OCTOBER','6 - 9 Months','1/A/01','HAJI NOOR',20.344,0,0,0)

advanced thanks