syntax error in insert into statement in vba

[iamsvs]

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

 

[smiler]

hi

the Query with variables formula results in

INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('string','string','string','string','string','string',numeric,numeric)
(this has 6 string values and 2 numeric values)

your 2nd example with values shows 6 string values and 4 numeric values

the insert is expecting 6 strings and 4 numerics so do you need to add cfexpense an commision variables to the first formula ?