"satinsoft" <satinsoft@d...> wrote in message 
news:0277F4C4-BFFF-41EB-9826-59C313701DDF@m......
> Hi,
> I'm getting a little lost using xsl.
> I have exported the schema of a database table in MSACCESS VBA using
> EXPORTXML  and wish to using TransformXML   to change an attribute 
> od:jetType
> the exported schema has the primary key field as
>
> <xsd:element name="USER_ID" minOccurs="1" od:jetType="decimal"
> od:sqlSType="decimal" od:nonNullable="yes">
>
> I want to transform this to change the field to an auto increment field,
> which
> I guess would require this
>
> od:jetType="autonumber" od:sqlSType="int" od:autoUnique="yes"
> od:nonNullable="yes" type="xsd:int"/>
>
>
> Any assistance would be appreaciated

So where are you stuck? If that's the only change you need then look for 
identity transformation on the web.
You then just need to add an extra rule to match the appropriate element and 
add the new attribute whilst not copying the old one.

-- 

Joe Fawcett (MVP - XML)
http://joe.fawcett.name