Macro OutputTo XML file

[dejanc]

Hi everyone,
I was looking macro OutputTo. I would like to export file in XML format with button, which will be apply with macro. But there is no options. Only a few formats are available.
Is that correct, or can be done somehow?

thanks in advance for help

 

[boblarson]

What version of Access are you using?

 

[boblarson]

You should be able to use (depending on your version) VBA code to do it:

Application.ExportXML ...

 

[MStef]

You don't need a Macro, do it via VBA.
Look at "DemoTblInXMLA2000.mdb" (attachment, zip).
Open Form1.

 

[amfreitas1]

MStef, I use your demo and it's perfect, but I would like to export to xml and convert elements in attributes. I would like too, keep null fields.

It's possible do that?

Thanks