From The official Microsoft Access online help:
"If you want to add, edit, or delete data, you make the changes in Excel, and refresh (or requery) the data in the Access table. However, you cannot edit the contents of the table in Access."



Here is the case. I have two xml file with slightly different schema, let's say A.xml and B.xml. I want to update B with some data from A. One way that I have thought of is to set up macro to update B, so there is no problem with that. Problem is, B is not exactly w3 approved schema. Since Access will automatically update my xml in the "correct" way, the access-exported B.xml will have different schema than the original B.xml. It is the same reason I also can't use Excel to do so.

Is there a VB hardcore way to force update or export B.xml?

Thanks