generate UTF-8 encoded file

  • Thread starter Thread starter Franz Dallinger
  • Start date Start date
F

Franz Dallinger

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

yours
franz
 
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.
 
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
 
Back
Top