[RESOLVED] update error

[bezaman]

I can't get this update to work. This is the error I get.
Syntax error (missing operator) in query expression

Private cnxnString As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\SPECTRUM\YMCA\db1.mdb")
    Private cnxn As New System.Data.OleDb.OleDbConnection(cnxnString)
    Private sql As New System.Data.OleDb.OleDbCommand
    Private myDataAdapter As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [DEDUPED]", cnxn)
    Private myDataAdapter2 As System.Data.OleDb.OleDbDataAdapter
    Private cmdBuilder As New System.Data.OleDb.OleDbCommandBuilder(myDataAdapter)
    Private tblDEDUPED As New DataTable
    Private tblCOMBINED As New DataTable
 
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Me.Cursor = Cursors.WaitCursor
        myDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
 
        myDataAdapter.Fill(tblDEDUPED)
 
        Dim myUnitID As String = Nothing
        Dim myUpdateSQL As String = Nothing
        myDataAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand
 
        For Each dbRow As DataRow In tblDEDUPED.Rows
            myUnitID = dbRow.Item("UNIT ID")
            myDataAdapter2 = New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [COMBINED] WHERE [UNIT ID] = '" & myUnitID & "'", cnxn)
            myDataAdapter2.Fill(tblCOMBINED)
 
            For j As Integer = 0 To tblCOMBINED.Rows.Count - 1
                dbRow.Item("NAME1") = "TEST"
            Next j
            myDataAdapter.Update(tblDEDUPED)
            tblCOMBINED.Clear()
        Next
 
        myDataAdapter.Dispose()
        myDataAdapter2.Dispose()
        cnxn.Close()
        cnxn.Dispose()
 
        Me.Cursor = Cursors.Default
        MsgBox("DONE!")
    End Sub

[bezaman]

figured it out. there were spaces in the field names. not good.

[MaximilianMayrhofer]

If UNIT ID is numeric, then you should not be using the single quotes. It should simply be:

"SELECT * FROM COMBINED WHERE [UNIT ID] = " & myUnitID