convert ACCESS to xml

[Manlio]

Hi,

can I get an XML file from a DB of ACCESS 97?
And From ACCESS 2000?

thanks

[Craig Clearman]

Manlio,

>can I get an XML file from a DB of ACCESS 97?
>And From ACCESS 2000?

Easy or pretty? It's easy to get the XML. You can simply use ADO to
get the recordset from your database. ADO can persist the data as XML.
But you won't like the XML that is generated. To get a logically
formatted XML document, you'll need to programmatically retrieve the
data.

Ciao, Craig

[Mike H]

"Manlio" <paterniti@effedue.com> wrote:
>
>Hi,
>
>can I get an XML file from a DB of ACCESS 97?
>And From ACCESS 2000?
>
>thanks
>
>

You can use an ADO Recordset and the DOM.
Retreive a recordset of the data you want
to convert to XML and then you can use the DOM
to do the conversion. You first have to determine
what you want the xml to look like, ie:

<table name="Customers">
<rows>
<row>
<fields>
<field name="id" value="1"/>
...
</fields>
</row>

<row>
<fields>
<field name="id" value="2"/>
...
</fields>
</row>

</rows>
</table>

[Erich]

On the easy side, you can persist it to XML and apply an XSL-Transformation
to get it in the XML grammar you want.

Erich

Craig Clearman <chclear@nospam.please> wrote:
>Manlio,
>
>>can I get an XML file from a DB of ACCESS 97?
>>And From ACCESS 2000?
>
>Easy or pretty? It's easy to get the XML. You can simply use ADO to
>get the recordset from your database. ADO can persist the data as XML.
>But you won't like the XML that is generated. To get a logically
>formatted XML document, you'll need to programmatically retrieve the
>data.
>
>Ciao, Craig
>

[Dik]

Maybe this can help you:

http://www.access2xml.nl/