"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