Export to XML

[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.

 

[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

 

[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.

 

[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).

 

[Tom van Stiphout]

On Tue, 22 Jun 2010 03:40:55 -0700 (PDT), MrMMM

Oops, rather than XMLHTTP, use MSXML library. Here are a few links:
http://www.freevbcode.com/ShowCode.Asp?ID=1919
http://msdn.microsoft.com/en-us/library/aa163921(office.10).aspx


-Tom.
Microsoft Access MVP

 

[MrMMM]

On Tue, 22 Jun 2010 03:40:55 -0700 (PDT), MrMMM


Oops, rather than XMLHTTP, use MSXML library. Here are a few links:http://www.freevbcode.com/ShowCode....ft.com/en-us/library/aa163921(office.10).aspx

-Tom.
Microsoft Access MVP

Thank you for the pointers! will take a look.