A
Anonymous Coward
OK, here's an easy one for you to help me with. I've got an .XML file,
which I want to be able to import into Access 2003 - this is the easy
part. The hard part is how to export the data from Access back to XML
so that the XML file has exactly the same structure as the file that was
originally imported. That is to say, I want to round-trip my XML data
into Access then back out again.
(i.e. I want to run some update queries on the data, then export it back
to XML) If someone can describe how to do it in the simplest case that
would be great. Eg use the example XML file from the Access help:
<?xml version="1.0"?>
<ORDER>
<CUSTOMER>Nancy Davolio</CUSTOMER>
<PRODUCT>
<ITEM>Mom's Boston Crab Meat</ITEM>
<PRICE>$10.00</PRICE>
<QUANTITY>1 Bottle</QUANTITY>
</PRODUCT>
</ORDER>
produces 2 tables, ORDER and PRODUCT, I change the price from $10 to $5,
then want to export to XML to get the original file back.
which I want to be able to import into Access 2003 - this is the easy
part. The hard part is how to export the data from Access back to XML
so that the XML file has exactly the same structure as the file that was
originally imported. That is to say, I want to round-trip my XML data
into Access then back out again.
(i.e. I want to run some update queries on the data, then export it back
to XML) If someone can describe how to do it in the simplest case that
would be great. Eg use the example XML file from the Access help:
<?xml version="1.0"?>
<ORDER>
<CUSTOMER>Nancy Davolio</CUSTOMER>
<PRODUCT>
<ITEM>Mom's Boston Crab Meat</ITEM>
<PRICE>$10.00</PRICE>
<QUANTITY>1 Bottle</QUANTITY>
</PRODUCT>
</ORDER>
produces 2 tables, ORDER and PRODUCT, I change the price from $10 to $5,
then want to export to XML to get the original file back.