Exporting SQL data into specific XML format

DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Exporting SQL data into specific XML format

  1. #1
    Join Date
    Dec 2005

    Exporting SQL data into specific XML format

    A client has handed me an XML specification, requiring mapping of hierarchical SQL data on our side into a significant XML format to hand off data to them.

    Really basic question; where do I begin? I assume this can be done with VB and ADO or even VBA in MS Access 2003, yes? Any recommendations on good resources/books that cover the breadth of requirements in one easy to get started place?

    Basically, how do you map hierarchical data fields into a defined XML format.

    Thank you.

  2. #2
    Join Date
    Dec 2005
    I'm having same problem (but exporting recordsets through ASP scripting) and was referred to the following examples which helped.

    http://www.thevbzone.com, select the "vb standard modules" link, then scroll down to the modXML.bas sample at bottom.

    Hope this helps. If you find something better, please let us know.

Similar Threads

  1. query tuning
    By dhaya in forum Database
    Replies: 11
    Last Post: 08-25-2003, 05:24 PM
  2. XML Generation from SQL Server
    By Madhu in forum Database
    Replies: 0
    Last Post: 07-14-2003, 09:26 AM
  3. need help with xml problem
    By Guillermo Hidalgo in forum XML
    Replies: 2
    Last Post: 05-22-2002, 03:49 AM
  4. Replies: 3
    Last Post: 03-07-2001, 05:54 PM
  5. XML into a string
    By Paul Maher in forum XML
    Replies: 1
    Last Post: 12-16-2000, 02:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center