I'm tring to import a small part off a large xlm file. Access gives me and
option to transform but I have to build a xsl file. So I'm using XML Notepad
to test. I get all the data in a single string when I run the transform on
the Output tab and don't know how to get it to show my tages. Access create
table and column names of host and ipaddress but only pull in one record, the
last one.
Here is my xsl file:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
exclude-result-prefixes="gsd"
xmlns:gsd="http://www.genesyslab.com/cs">

<xslutput method="xml"/>
<xsl:template match="/">
<Host>
<xsl:for-each select="gsd:CfgData/gsd:CfgCreate/gsd:CfgHost">
<HostName><xsl:value-of select="@name"/></HostName>
<IPAddress><xsl:value-of select="IPaddress"/></IPAddress>
</xsl:for-each>
</Host>
</xsl:template>
</xsl:stylesheet>

If you need more info let me know.

thanks.