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
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.