Import xml and preserve character encoding

[inspectorgadjet]

Hi,

I am currently a SQL DBA, and have been roped in to help a fellow staff member import some XML data into an access database. I am using Office 2003, and the Get External Data command. It successfully imports all of the data, but my colleague says that it is not acceptible because the data is being converted to UTF-8 encoding. He would like it to retain the same original encoding as the XML file. Is there any way I can do this?

Thanks.

 

[The_Doc_Man]

Access is not, in and of itself, an XML processor or a web page processor. It is not a word processor. It converts things to whatever format it thinks it can handle. Whether that is UTF-8 or some other format.

Part of the problem is that using the Get External Data option invokes a "wizard" to import that information according to whatever the wizard thinks is the right thing to import. Other than choosing another import format (and thereby making the data potentially unusable within Access), I don't know of a good solution.