Erro in query

Hi all please tell me where I am doing the mistake iun the fllowing query

Query = "Insert into TblHrt (FldName,FldValue,FldType) Values (" & PrOpNam(j) & "," & PrOpVal(j) & "," & PrOpTyp(j) & ");"

Conn.Execute Query, IntAffRowCnt



Thanks

There are no syntax errors in your code. The only thing I can suggest, for fields that are strings delimit the values with single quotes.

Post the error message.

you do not need the last semicolon in your syntax

Thank you brucevde,
It is working now , as you said I missed the single quotes

Rajamani