Convert XML UTF-16 to UTF-8

Question

I am trying to import xml files in to MS Access, but I receive an error.

*Access has encountered an error processing the XML schema in the file 'XML File 01.xml'

Unable to switch the encoding.*

The first line of the XML file is

<?xml version="1.0" encoding="utf-16"?>

When I edit it in notepad to be

<?xml version="1.0" encoding="utf-8"?>

It loads fine.

The problem is I have +1000 files, so doing it manually is not an option. Is there a batch file I can write? or another option regarding MS Access or VB?

You might try like described here: http://stackoverflow.com/questions/60034/how-can-you-find-and-replace-text-in-a-file-using-the-windows-command-line-envir — Marged, Jul 02 '15 at 09:32

score 1 · Accepted Answer · answered Jul 07 '15 at 13:59

1

fnr.exe - Find And Replace Tool.

https://findandreplace.codeplex.com/

answered Jul 07 '15 at 13:59

Data_101

835
4
13
25

Convert XML UTF-16 to UTF-8

1 Answers1