How to "expand" the INSERT command?

[AlvaroF1]

I'm using the INSERT command do add records to my database.

The problem is that I'm getting an error and I can't know where is it from becouse my database has many fields.

Dim myCommand As OleDb.OleDbCommand
myCommand.CommandText = "INSERT INTO myTable (myField1,myField2,myField3,myField4,myField5) VALUES ('" & _
TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" TextBox4.Text & "','" & TextBox5.Text & "')"
myCommand.ExecuteNonQuery()

Is there another way to add records?