Automatically export a query to XML with Access 2003

[CCripe]

I need to export data from an Access query to an XML file on our network. I
can do this manually by using File=>Save As=>XML but this needs to happen
several times a day, so want to do it automatically. I have a VB Script that
will automatically open the database, but I cannot figure out how to do the
export either via the VB Script or by using a macro. VB Script will
automatically run a macro, but I cannot figure out how to use a macro to save
query to xml format...only xls.

Any help on this, or even a better idea on how to do it, is appreciated.

 

[bhicks11 via AccessMonster.com]

Have a look at TransformXML in the VBA help.

Bonnie
http://www.dataplus-svc.com