Transform attribute to element ???

[Frukten]

I'm trying to import an XML document into Access 2003. I Need a XSL file to
transform it to avoid Access from truncating the attributevalues.

This is the structure of the XML file.

<Library>
<Book name="Bookname">
<Chapter nr="1">
<Paragraph nr="1">Paragraphtext...</paragraph>
<Paragraph nr="2">Paragraphtext...</paragraph>
</Chapter>
<Chapter nr="2">
<Paragraph nr="1">Paragraphtext...</paragraph>
</Chapter>
</Book>
</Library>


This is the output i want after transformation:

<Library>
<Paragraph>
<Book>Bookname</Book>
<Chapter>1</Chapter>
<Paranr>1</Paranr>
<Paratext>Paragraphtext...</Paratext>
</Paragraph>
<Paragraph>
<Book>Bookname</Book>
<Chapter>1</Chapter>
<Paranr>2</Paranr>
<Paratext>Paragraphtext...</Paratext>
</Paragraph>
<Paragraph>
<Book>Bookname</Book>
<Chapter>2</Chapter>
<Paranr>1</Paranr>
<Paratext>Paragraphtext...</Paratext>
</Paragraph>
</Library>

I'm totally lost, thankful for help
/Fredrik

 

[tsuji]

What have you tried sofar?