How do I export XML data from Access 2002/2003 using a macro?

C

CaptainRoleplay

I can manually export the data by choosing Save As and XML as the filetype,
but how do I automate it using a macro or VBA code? The macro OutputTo does
not allow me to select XML as a filetype.. it's just not in the list.
Doesn't seem to make sense, but it's the same in my Access 2002 at work and
2003 at home.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show customUI when I launch the contextMenu from a VBA macro 0
XML into Access 2003 3
Ecporting Access Data to Multiple XML files 1
Saving as XML 0
MS Access 2002, OutputTo and xml 1
Exporting XML data from Access 2003 0
Export Data to Multiple XML Files 1
Automatically export a query to XML with Access 2003 1

Top