title: Inserting MS Access Row Into Database using vb.net
body: <p>So im trying to add fields to a database. It is .mdb database, microsoft access.</p>
  
  <p>The Name of the table is Contacts.</p>
  
  <pre><code>Dim con As New OleDb.OleDbConnection
      Dim dbProvider As String
      Dim dbSource As String
      Dim ds As New DataSet
      Dim da As OleDb.OleDbDataAdapter
      Dim sql As String
  
      dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
      dbSource = "Data Source= C:\Users\Owner\Desktop\Contacts.mdb"
  
      con.ConnectionString = dbProvider &amp; dbSource
  
      con.Open()
  
      sql = "INSERT INTO Contacts (FName, LName, Age, Address Line 1, Address Line 2, City, State, Zip, Home Phone, Work Phone, Email, Sex) VALUES (a, b, c,d,e,f,g,h,i,j,k)"
      da = New OleDb.OleDbDataAdapter(Sql, con)
      da.Fill(ds, "Contacts")
  </code></pre>
  
  <p>My Error is Syntax error in INSERT INTO statement. Which makes no sense, whatsoever. What am i doing wrong?</p>
  
  <p>EDIT*
  I solvedmy riginal problem by adding [] around certian fields as suggested, thanks. Now I am getting...</p>
  
  <p>No value given for one or more required parameters.</p>
  
  <p>The database has a primary ID field that autoincrements, does this change anything?</p>