I have the following code to write an xml file from "rsPick" and then merge "rsPick" with "rsArchive"


'''''''''''''code''''''''''''''''''
dsPick.WriteXml("C:\mydata.xml")

daArchive.FillSchema(dsArchive,SchemaType.Source, "tblPick")
daArchive.Fill(dsArchive, "tblPick")

dsArchive.Merge(dsPick)
daArchive.Update(dsArchive, "tblPick")
'''''''''''''''''''''''''''''''''''''


The xml file is written away succesfully but when I look at "tblPick" which is the access table acting as the source for dsArchive no new rows have been added!

What am I doing wrong?

Both schemas are similar.
This is driving me nuts.