XML Data

[Guest]

Good morning,

How can I 'export' data from a query into an xml file?

Thank you,

Daniel

 

[ChrisM]

What version of Access are you using?

 

[Guest]

I would like to know how to perform this action for both 2000 and 2003, but
2003 is my priority right now.

Daniel

 

[ChrisM]

I've not used Access2003, but I was under the impression that it supported
XML natively, ie there should be an option to export as XML built in
somewhere.

Maybe one of the experts in here could either put me right, or tell you
where to find it.

If I'm wrong, I guess your only option would be to write or buy a utility
that will convert from Access to XML. Not hugely difficult if you have some
programming skills, though depending on the complexity of what you actually
want to produce...

Chris.

 

[ChrisM]

Actually,

Have a look at this:

http://tinyurl.com/fpwqt

Cheers,

Chris.

 

[Brendan Reynolds]

As Chris says elsewhere in this thread, Access 2003 has some built-in
support for XML. For earlier versions (or if the built-in features don't
meet your needs) you can set a reference to Microsoft's XML parser,
msxml.dll (or msxml2.dll, msxml3.dll, etc.) and call its methods from VBA.
Here's a link to the MSXML documentation on MSDN ...

http://msdn.microsoft.com/library/d...html/b24aafc2-bf1b-4702-bf1c-b7ae3597eb0c.asp