Dear Experts

i am getting "Syntax error in INSERT INTO statement" when i try the following

Dim aRow As DataRow = ds.Tables("Friends").NewRow

Dim cmdBld As OleDbCommandBuilder

aRow("Fname") = "Sam"

aRow("Lname") = "Davis"

aRow("Area") = "Bronx"

ds.Tables("Friends").Rows.Add(aRow)

cmdBld = New OleDbCommandBuilder(daFriends)

daFriends.Update(ds, "Friends") '--- **It is here i get the error**

ds.Tables("Friends").AcceptChanges()

Please help and Thanks in advance

Manish

So near yet so far away.....