xml and vb6

Hi how can I generate an XML file through VB 6
and set the heading and variable value based on data from SQL 2000 tables.

Thanks
Dib
here is a sample on how the xml file will look

<STORE>
<AUTH_KEY>carp1di3m</AUTH_KEY>
<REQUEST_ID>W;;123456;2714;15900;JUDGMENT;[0];2005-03-22;14:48:28;NJ</REQUES
T_ID>
<WEB_ORDER>12345</WEB_ORDER>
<REFERENCE>test</REFERENCE>
<REPORT>
<REPORT_TYPE>UCC</REPORT_TYPE>
<REPORT_FOLDER>1111591708</REPORT_FOLDER>
<STORE>
an so on


.

Relevant Pages

  • Re: Store XML in a Database
    ... > Access database, by the help of SQL. ... Do you need to just store the XML string or convert it into its ... the XML file maps to the database. ...
    (comp.lang.java)
  • problem while loading xml doc to a schema based table]
    ... One stage of my project is to store an xml file into a table of ... SQL> ALTER SESSION SET EVENTS='31098 trace name context forever'; ... SQL> create table struc_100kb(xmldoc sys.xmltype) ... xmltype column xmldoc store as object relational ...
    (comp.databases.oracle.server)
  • Store XML in a Database
    ... I need to figure out how you store a XML file down in a ... Access database, by the help of SQL. ...
    (comp.lang.java)
  • Re: small data needed - suggestions?
    ... Or store it in a xml file ... "waste" one on a small project like this. ... SQL Express is not supported either. ...
    (microsoft.public.dotnet.framework.aspnet)
  • SQL 2000 data to Custom XLM
    ... <STORE> ... <REPORT> ... from SQL 2000 tables or SP?. ... Dib ...
    (microsoft.public.sqlserver.xml)
Loading