generate UTF-8 encoded file

[Franz Dallinger]

How can i generate UTF-8 encoded files out from VBA
(for generatin an XML - File)

yours
franz

 

[John Nurick]

Hi Franz,

If you're exporting a table or query, you can select UTF-8 in the "code
page" list in the Advanced dialog in the Text Export Wizard.

But if you want to create UTF-8-encoded strings in VBA and write them
direct to disk I honestly don't know what's the best way. I'd start with
a web search for VB libraries or controls that can do it.

 

[Angel Popov]

Hi Franz,
You can write xml data using msxml

Dim oXML As New MSXML2.DOMDocument
oXML.loadXML ("<root>Your utf-8 string […] </root>")
oXML.Save (fileName)

Regards, Angel