Exporting as XML

[flaviooooo]

Hey,

I'm trying to export a query to XML format, but don't know how to do it properlY...

I'm using the following at the moment:

Dim stDocName As String
stDocName = "Q_STOCK_LABEL_RM"

DoCmd.OutputTo acOutputQuery, stDocName, acFormatXML, "C:\test.xml", False, ""

But this only pops up the 'Output To'-screen, where I need to manually select XML again.

Is there a way to bypass this part?

Kind regards
F

 

[PHV]

Which version of access admits acFormatXML ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[flaviooooo]

Hey, I don't think it's actually a supported code but I use Access 2003.

It doesn't work the way it's supposed to however...

 

[ZmrAbdulla]

look for "ExportXML Method" in the help

________________________________________________________
Zameer Abdulla
Help to find Missing people