How can I programmatically export an Access table into XML?

J

Jim

I'm somewhat familiar that this is possible in Access 2002, and I have seen a few code snippets done in (I assume...) VBA, however, I would like to do this through a Perl script external to Access. Is this possible through OLE Automation? Thanks for any insight you can provide

Ji
 
J

John Nurick

Hi Jim,

It should be possible (Application.ExportXML) though Access is fussier
about being automated than the other Office apps are. See

Using Microsoft Access as an Automation Server
http://support.microsoft.com/?id=147816 (Access 97)
http://support.microsoft.com/?id=210111 (Access 2000 but applies to
2002)

and if relevant
Considerations for Server-Side Automation of Office:
http://support.microsoft.com/?id=257757
Configure Office Applications to Run Under a Specific User Account
http://support.microsoft.com/?id=288367
 

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

programmatically exporting data to XML in Access 2002? 2
Automating Access: running your own functions/passing arguments 3
Delimited Export Specification - independent of table 3
Exporting XML data from Access 2003 0
Export to XML 5
Exporting an table to XML 0
export to xml 1
XML Import & Export in Access 2003 2

Top