I'm trying to import/merge/update a table from an xml file.

To import I'm using the following code:
Private Sub Command0_Click()

Const acAppendData = 2
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "DATABASE LOCATION"
objAccess.ImportXML "HTTP OF XML FILE", acAppendData

End Sub
This works perfectly to import new records, however what I also need it to do is merge/update the data. So the xml file will contain the correct data and any amendments need to be made to the Access table.

Any help greatly appreciated.


PS I'm using Access 2010