help to import XML into MS Access using xsl

A

Antonio

Adobe Indesign exports xml files from our application with the
following format:
<root>
<headline></headline>
<story>
<byline></byline>
<text></text>
</story>
</root>
When I try to import those xml files into MS Access 2003 using then
Application.ImportXML method, Access creates two tables because the
<story> tag creates a sub level.
The fact is that I do not need that tag.
To eliminate it, I tried the domIn.transformNodeToObject domStylesheet,

domOut in MS Access.
But I need to create the xsl script for the domStylesheet that will
find <story> and </story> and delete them. I don't know how to do that.

I tried several times but I am not able to make it work

Any help available?
 

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

Top