Dealing with importing and exporting of XML files and it being altered by Access.

[edmscan]

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

[orange]

Why not make a copy.. import what you need into Access. Then use the original, in it's still original state, for whatever else you want to do.

We really need to see what is the XML;
what do you do with it in Access; and
why do you still need the original for further processing?

[edmscan]

Actually yes .. I decided that I will import the data and edit the file manually. I will not be doing it often. So it will work.