I am trying to write data to an access table from vb.net. The code all seems to run fine but no data is being sent to the db though!
the code i have got is
Dim itemcount As Integer Dim MyCn As OleDbConnection Dim sql As String 'Dim Value As String Dim Command As OleDbCommand Try con.Open() MyCn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\BillAnalyst\ReferenceData.mdb") For Each ListView In lstErrors.Items itemcount = itemcount + 1 sql = "INSERT INTO CAllRates (CallRates.Destination) VALUE (" & ListView & ")" Command = New OleDbCommand(sql, MyCn) Next Catch ex As Exception MessageBox.Show(ex.Message & " - " & ex.Source) con.Close() End Try lblcount.Text = itemcount
I wondered if anyone had ideas what i was doind wrong