1. G

    Question INSERT INTO exception

    Hi, everybody, i've dev a program that access to an mdb database and insert a new record with the command INSERT INTO but when i execute the db command with ExecuteNonQuery the program catch an exception that i did not understand. I post the oledbcommand line and the fields of the access mdb...
  2. J

    Question using OleDbCommand

    hi, i am trying to insert some data from a dataset into a database. i have used the following code that works absolutly fine. For Each dr In myDataSet.Tables(0).Rows strSQL = "INSERT INTO [~AgeBandsEmpty] (a,b,c) VALUES ('" & dr ("a") & "','" & dr ("b") & "','" & dr ("c") & "')"...