XML transformed as USC-2 rather than UTF-8

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

<xsl:eek:utput 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
 

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