Export to XML

M

MrMMM

Hi,
I've looked through this group but did not find the answer that would
fit my particular problem.
We have a very old application that is written in access. The data
from this app needs to be provided to a partner in XML format. The
problem is that the partner requires a very specific format. I
understand that Access can to an export to XML where each field will
become an element.
I however, need more flexibility, for example to define blocks and
have elements which have information in the element itself.
For example this is what the XML document needs to look like:
<?xml version="1.0" encoding="utf-8"?>
<document>
<data>
<record>
<block1>
<element1>XXX</element1>
<element2="number">YYY</element2>
</block1>
<block2>
<element3>XXX</element3>
<element4>YYY</element4>
</block2>
</record>
<record>
<block1>
<element1>XXX</element1>
<element2="number">YYY</element2>
</block1>
<block2>
<element3>XXX</element3>
<element4>YYY</element4>
</block2>
</record>
</data>
</document>

Is this possible to do in acccess, or is there a software that would
allow to create a "mapping" of access data to a custom XML like this?

Thank you.
 
T

Tom van Stiphout

On Mon, 21 Jun 2010 07:40:41 -0700 (PDT), MrMMM

You can write some VBA and set a reference to the XMLHTTP module to
use its functionality to make this happen.

-Tom.
Microsoft Access MVP
 
M

MrMMM

Tom,
Thank you for the reply. Can you please elaborate, or maybe point me
in the direction of where I can read up on this?

Thank you.
 
M

MrMMM

Also, maybe I wasn't clear, but the data needs to be provided in an
XML file, not feed (I am not sure if there is a difference).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top