Thread: Syntax error INSERT INTO
View Single Post
  #1 (permalink)  
Old January 30th, 2006, 01:19 PM
ITladybug ITladybug is offline
Registered User
  
Join Date: Dec 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Syntax error INSERT INTO
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

Reply With Quote