How can I programmatically export an Access table into XML?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top