Defining data types in XSL - XSL - XML

gwiggins · #1 (**permalink**) 09-06-2008, 12:23 AM

Using an XSL file as a transform definition file, I am attempting import an XML file into MS Access. In the XSL file, I dynamically create an additional tag named 'Key' that is used to hold the position number. The problem is that when I import the XML file with the XSL file as the transform, the column 'Key' gets defined as a data type of Text. I want it to be an integer data type. Is there a way to cause MS Access to create this column with the data type as integer?
XML file:
<Records>
<Record>
<Name>Some Name</Name>
</Record>
</Records>

XSL file:
<xsl:template match="Records">
<html>
<body>
<table>
<xsl:apply-templates select="Record"/>
</table>
</body>
</html>
</xsl:template>
<xsl:template match="Record">
<Record>
<Key>
<xsl:number value="position()"/>
</Key>
<Name>
<xsl:value-of select="Name"/>
</Name>
</Record>
</xsl:template>