Unanswered: Insert all records from dataset into datasource?
Forgive my cluelessness...this should be easy, but it's not working for me. I have a dataset which is filled with selected records from one datasource, and I want to put those records into a different, empty datasource. I know the dataset (ds) is right cuz I wrote it to XML. How do I Insert the records to the empty datasource (dcExport)? The following code DOESN'T work:
cmdInsertSites = New OleDbCommand
.CommandType = CommandType.Text
.CommandText = "Insert Into Sites " & _
"(SiteID) " & _
.Parameters.Add(New OleDbParameter("@SiteID", OleDbType.VarChar, 10))
.Parameters("@SiteID").SourceColumn = "SiteID"
.Connection = dcExport