Export Query To XML

  • Thread starter Thread starter PC Datasheet
  • Start date Start date
P

PC Datasheet

In Access2002, File - Export provides a way to manually export a query to a
XML file. Can it be done with VBA? How?

Steve
 
PC Datasheet said:
In Access2002, File - Export provides a way to manually export a
query to a XML file. Can it be done with VBA? How?
Click to expand...

DoCmd.OutputTo will do it, but I can't find a way to keep it from
prompting for whether to export the schema or not. But poking around in
the object browser, I found the Application.ExportXML method, which I
didn't know existed. It's in the help file, though, in the Microsoft
Access Visual Basic Reference.
 
Thanks, Dirk! Appreciate the help.

Steve


Dirk Goldgar said:
DoCmd.OutputTo will do it, but I can't find a way to keep it from
prompting for whether to export the schema or not. But poking around in
the object browser, I found the Application.ExportXML method, which I
didn't know existed. It's in the help file, though, in the Microsoft
Access Visual Basic Reference.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 

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

Cannot export Access 2007 Report into Excel 5
Export query to XML file 4
Export query to Excel fails 6
XML export 3
Export to XML - error 31532 0
How to export XML file per record? 6
XML Import & Export in Access 2003 2
Excel 2007 XML Export 1

Back
Top