N
Nick
I am trying to use TransformXML in Access 2003. When I use the example code
Application.TransformXML _
DataSource:="C:\Employees_In.xml", _
TransformSource:="C:\Employees_In.xsl", _
OutputTarget:="C:\XformedEmployees.xml", _
WellFormedXMLOutput:=False
with the example XML from
Access 2003 Sample: New XML Features in Access 2003
odc_accessnewxmlfeaturessample.EXE
I changed the output method to XML
<xslutput method="xml" encoding="UTF-8" />
and I get a well formed XML file XformedEmployees.xml but in USC-2 Little
Endian encoding. I need to get an output file in UTF-8 encoding. How do I do
that?
ExportXML has a variable to set the encoding, but TransformXML doesn't.
Thanks
Nick
Application.TransformXML _
DataSource:="C:\Employees_In.xml", _
TransformSource:="C:\Employees_In.xsl", _
OutputTarget:="C:\XformedEmployees.xml", _
WellFormedXMLOutput:=False
with the example XML from
Access 2003 Sample: New XML Features in Access 2003
odc_accessnewxmlfeaturessample.EXE
I changed the output method to XML
<xslutput method="xml" encoding="UTF-8" />
and I get a well formed XML file XformedEmployees.xml but in USC-2 Little
Endian encoding. I need to get an output file in UTF-8 encoding. How do I do
that?
ExportXML has a variable to set the encoding, but TransformXML doesn't.
Thanks
Nick