Error while inserting data into a access database in vb 2010

Question

I am using the below code for saving data into a MS-Access 2007 table. But it throw a expression as follows:

{"Syntax error (missing operator) in query expression '0','0','0','0','0','0','0','0')'."}

I have attached the code below:

cmd.CommandText = "INSERT INTO Daily_EB_Consumption (EB_S1, EB_S2, EB_S3, EB_S4, EB_S5, EB_Indus, EB_LH, EB_Total, EB_Date) " & _
    " VALUES(" & Me.txt_S1.Text & "','" & _
      Me.txt_S2.Text & "','" & Me.txt_S3.Text & "','" & Me.txt_S4.Text & "','" & _
      Me.txt_S5.Text & "','" & Me.txt_Indus.Text & "','" & Me.txt_LH.Text & "','" & _
      Me.txt_Total.Text & "','" & Me.dt_EB.Value & "')"

Please anyone help with this error

Community · Accepted Answer · 2017-05-23 11:45:08Z

1

You have used the apostrophe but only on the right side. You have to wrap the values in apostrophes:

VALUES('" & Me.txt_S1.Text & "', ...

But you are open for SQL-Injection, so you should use parameters.

using parameters inserting data into access database

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Jul 8, 2013 at 7:57

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2559865 Over a year ago

Thanks for your Help Mr. Tim... Now the code is working properly

Collectives™ on Stack Overflow

Error while inserting data into a access database in vb 2010

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related