"Joe Fawcett" wrote:

> "Roger" <Roger@d...> wrote in message 
> news:70E5DC93-728A-42F0-BD4E-261F0544E1F6@m......
> >I have data in Access 2003 that I want to import into another application.
> > The application requires a specific format to import XML files.  Below are
> > two samples.  The first shows the XML file that I get when I export from
> > Access.  The second shows the format I need.  What is the correct term for
> > making such a change and what tool should I use?
> >
> > Access Format:
> > <JV_DOC_HDR>
> >         <DOC_CD><JVA></DOC_CD>
> >         <DOC_DEPT_CD><005></DOC_DEPT_CD>
> >         <DOC_ID><OW01453963005></DOC_ID>
> >         <DOC_VERS_NO><1></DOC_VERS_NO>
> >      </JV_DOC_HDR>
> >      <JV_DOC_LNGRP>
> >         <DOC_CD><JVA></DOC_CD>
> >         <DOC_DEPT_CD><005></DOC_DEPT_CD>
> >         <DOC_ID><OW01453963005></DOC_ID>
> >         <DOC_VERS_NO><1></DOC_VERS_NO>
> >         <DOC_LNGRP_NO><24138607></DOC_LNGRP_NO>
> >      </JV_DOC_LNGRP>
> >      <JV_DOC_ACTG>
> >         <DOC_CD><JVA></DOC_CD>
> >         <DOC_DEPT_CD><005></DOC_DEPT_CD>
> >         <DOC_ID><OW01453963005></DOC_ID>
> >         <DOC_VERS_NO><1></DOC_VERS_NO>
> >         <DOC_ACTG_NO><24138608></DOC_ACTG_NO>
> >         <DOC_ACTG_LN_NO><1></DOC_ACTG_LN_NO>
> >         <DOC_LNGRP_NO><24138607></DOC_LNGRP_NO>
> >         <FUND_CD><0123></FUND_CD>
> >         <DEPT_CD><005></DEPT_CD>
> >         <ACTG_LN_DSCR><OUTDATED WARRANT WARRANT NUMBER = 01453963 ISSUE
> > DATE = 06222005></ACTG_LN_DSCR>
> >      </JV_DOC_ACTG>
> >      <JV_DOC_ACTG>
> >         <DOC_CD><JVA></DOC_CD>
> >         <DOC_DEPT_CD><005></DOC_DEPT_CD>
> >         <DOC_ID><OW01453963005></DOC_ID>
> >         <DOC_VERS_NO><1></DOC_VERS_NO>
> >         <DOC_ACTG_NO><24138609></DOC_ACTG_NO>
> >         <DOC_ACTG_LN_NO><2></DOC_ACTG_LN_NO>
> >         <DOC_LNGRP_NO><24138607></DOC_LNGRP_NO>
> >         <FUND_CD><0123></FUND_CD>
> >         <DEPT_CD><005></DEPT_CD>
> >         <ACTG_LN_DSCR><OUTDATED WARRANT WARRANT NUMBER = 01453963 ISSUE
> > DATE = 06222005></ACTG_LN_DSCR>
> >      </JV_DOC_ACTG>
> >
> > Format Needed:
> > <AMS_DOCUMENT DOC_CAT="JV" DOC_TYP="JV" DOC_CD="JVA" DOC_DEPT_CD="005"
> > DOC_UNIT_CD="null" DOC_ID="OW01453963005" DOC_VERS_NO="1"
> > AUTO_DOC_NUM="false" DOC_IMPORT_MODE="OE">
> >      <JV_DOC_HDR AMSDataObject="Y">
> >         <DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
> >         <DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
> >         <DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
> >         <DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
> >      </JV_DOC_HDR>
> >      <JV_DOC_LNGRP AMSDataObject="Y">
> >         <DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
> >         <DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
> >         <DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
> >         <DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
> >         <DOC_LNGRP_NO Attribute="Y"><![CDATA[24138607]]></DOC_LNGRP_NO>
> >      </JV_DOC_LNGRP>
> >      <JV_DOC_ACTG AMSDataObject="Y">
> >         <DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
> >         <DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
> >         <DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
> >         <DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
> >         <DOC_ACTG_NO Attribute="Y"><![CDATA[24138608]]></DOC_ACTG_NO>
> >         <DOC_ACTG_LN_NO Attribute="Y"><![CDATA[1]]></DOC_ACTG_LN_NO>
> >         <DOC_LNGRP_NO Attribute="Y"><![CDATA[24138607]]></DOC_LNGRP_NO>
> >         <FUND_CD Attribute="Y"><![CDATA[0123]]></FUND_CD>
> >         <DEPT_CD Attribute="Y"><![CDATA[005]]></DEPT_CD>
> >         <ACTG_LN_DSCR Attribute="Y"><![CDATA[OUTDATED WARRANT WARRANT
> > NUMBER = 01453963 ISSUE DATE = 06222005]]></ACTG_LN_DSCR>
> >      </JV_DOC_ACTG>
> >      <JV_DOC_ACTG AMSDataObject="Y">
> >         <DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
> >         <DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
> >         <DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
> >         <DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
> >         <DOC_ACTG_NO Attribute="Y"><![CDATA[24138609]]></DOC_ACTG_NO>
> >         <DOC_ACTG_LN_NO Attribute="Y"><![CDATA[2]]></DOC_ACTG_LN_NO>
> >         <DOC_LNGRP_NO Attribute="Y"><![CDATA[24138607]]></DOC_LNGRP_NO>
> >         <FUND_CD Attribute="Y"><![CDATA[0123]]></FUND_CD>
> >         <DEPT_CD Attribute="Y"><![CDATA[005]]></DEPT_CD>
> >         <ACTG_LN_DSCR Attribute="Y"><![CDATA[OUTDATED WARRANT WARRANT
> > NUMBER = 01453963 ISSUE DATE = 06222005]]></ACTG_LN_DSCR>
> >      </JV_DOC_ACTG>
> >      </AMS_DOCUMENT>
> >
> I think your best option would be to use an XSL transformation. This a piece 
> of declarative code which specifies how the input XML should be mapped to 
> the output.
> It's not going to be easy to learn quickly so if you get stuck let us know.
> (The XML in the first example is not well formed, for example
> <JV_DOC_HDR>
>         <DOC_CD><JVA></DOC_CD>
> 
> JVA should probably be <JVA/>
> 
> so post the actual XML if you need more help.
> 
> -- 
> 
> Joe Fawcett (MVP - XML)
> 
> https://mvp.support.microsoft.com/profile=8AA9D5F5-E1C2-44C7-BCE8-8741D22D17A5 
> 
>
I'm not even sure where to start to create a transformation.  I'm familiar 
with the term and that's about it.  Can you suggest a book or online resource 
to get me started.  Also, I've heard of tools that allow you to manipulate 
various data files (Data Junction for example).