Macro OutputTo XML file (1 Viewer)

D

dejanc

Registered User.

Local time

Today, 00:26

Joined

Aug 4, 2009

Messages

45

• Sep 15, 2009

• #1

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

Smeghead

Local time

Today, 00:26

Joined

Jan 12, 2001

Messages

32,059

• Sep 15, 2009

• #2

What version of Access are you using?

 

boblarson

Smeghead

Local time

Today, 00:26

Joined

Jan 12, 2001

Messages

32,059

• Sep 15, 2009

• #3

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

Application.ExportXML ...

 

M

MStef

Registered User.

Local time

Today, 08:26

Joined

Oct 28, 2004

Messages

2,251

• Sep 16, 2009

• #4

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

 

Attachments

• DemoTblInXMLA2000.zip

  14.8 KB · Views: 1,113

A

amfreitas1

New member

Local time

Today, 04:26

Joined

Mar 4, 2011

Messages

3

• Mar 4, 2011

• #5

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

 

Last edited: Mar 4, 2011