XSL-Problem Importing XML

F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import XML-File using XSL-Transformation and creating numeric fields 0
Export to Word via XML 0
Importing Project 2007 XML data into Access 2007 0
Trouble Importing XML File using XSL 0
update to secondary XML output (w/ transforming XHTML --> HTML) 0
xsl to filter tables from xml 0
Access 2007 fails to execute saved XML import 0
Importing XML bill of materials 4

Top