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
    Posts
    1

    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
    Posts
    1
    I'm having same problem (but exporting recordsets through ASP scripting) and was referred to the following examples which helped.

    http://p2p.wrox.com/topic.asp?whichp...D=30756&#72152
    also
    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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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