Can any one help here. I have a CSV text file that needs to be placed into an existing database. I have read the data into a datagrid and created a dataset. For my database, I created another datagrid and dataset. I merged the CSV dataset into the datavase dataseta and the merged data shows up in the datagrid.

How do I transfer the merged datagrid to my database? Here is what I am trying to do, but nothing seems to add the merged data into my database. The objdataset table is identical in format to ds1.

Dim mysql As String
Dim conn As OleDbConnection
Dim connstr As String

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ProjectFolder & "\" & ProjectName & "\points.mdb"

conn = New OleDbConnection(connstr)

conn.Open()

Dim str As String

str = "SELECT * FROM CoordList"

Dim da1 As New OleDbDataAdapter(str, conn)

Dim ds1 As New DataSet("CoordList")

da1.Fill(ds1, "CoordList")

ds1.Merge(objDataSet)

MainDataGrid.DataSource = ds1.DefaultViewManager

ds1.GetChanges()

da1.Update(ds1, "CoordList")

ds1.AcceptChanges()

conn.Close()