Ok .. I have an XML file and I would like to be able to import the xml file into Access and manipulate it and spit it back out .. and have it still be usable, ie unaltered.
So .. the top of the file is like this:
<?xml version="1.0"?>
<ArrayOfMemoryEntry xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
The end of the file is like this:
</ArrayOfMemoryEntry>
So I can import the data into Access and do as I need .. mostly I will be appending data into the table.
But I need to spit it back out .. and that is the tough part as Access wants to change the top and bottom of the file. The data part (the middle of the file) is fine .. it is the top and bottom that it changes on export.
For example .. it changes it to:
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" generated="2015-11-03T02:54:46">
and the ending:
</dataroot>
I need it to be unaltered .. as the program reading the file after does not accept the changes.
I don't want to have to edit it manually in any fashion. I just want to edit the data as needed and leave the rest as it was originally.
I hate XML .. I will be honest, but I need a solution.
Thanks in advance ..
edmscan