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
With cmdInsertSites
.CommandType = CommandType.Text
.CommandText = "Insert Into Sites " & _
"(SiteID) " & _
"Values (@SiteID)"
.Parameters.Add(New OleDbParameter("@SiteID", OleDbType.VarChar, 10))
.Parameters("@SiteID").SourceColumn = "SiteID"
.Connection = dcExport
End With

daeSites.Update(ds, "Sites")