I'm trying to insert new row into Access database in vb.net. My insert into statement is like this where strjobno(string type) comes from textbox.

"insert into MasterJobT(job#,jobstartdate,projectedcompletionda te) values ('" & strJobNo & "',#01/10/2002#,#01/10/2002#)"

when I execute query it gine me 'Syntax error INSET INTO' statement.

How to solve this problem? Do u guys see any syntax error in there?

Thanks

Hi ITladybug,
Check the data type of job# if it's number change the string as

"insert into MasterJobT(job#,jobstartdate,projectedcompletionda te) values (" & strJobNo & ",#01/10/2002#,#01/10/2002#)"

If still you are getting an error please let us know the error number and the description


nalaka hewage

Thanks for the reply. Job# is of type string. I've another question. I've column of type currency. I've declare variable with type decimal to store currency value. Am I correct ? PLease help me to solve this 'INSERT INTO' syntax error.

Thanks