Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access queries to XML Conversion (2000)

    I want to create an XML document from an access query in order that I can publish a catalogue of goods on the internet. I have seen elsewhere in the lounge posts about XPs support for creating XML documents from Access objects. Does Access 2000 have any support for this kind of task or will I have to write a VBA module to convert a recordset into an XML document myself?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access queries to XML Conversion (2000)

    Access 2000 allows you to persist an ADO recordset as XML. Access XP offers greater support for XML. The Access 2000 syntax is something like this:

    rstADO.Save "C:ExportData.xml", adPersistXML

    As an afterthought, Access 2000 does not create any kind of XSL file for you. You have to create that yourself. I believe Access XP does some of that for you as well.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •