Help! Character Encoding Problem when exporting from Access to XML

[Mark H]

I export a Access table as a txt file every week to a third party provider
who distributes the file in XML form to online clients. Recently characters
have started to not translate onto sites; usually quotes and apostrophes. I
have been told by the third party service that this is due to a problem from
cutting-and-pasting btw Excel, Word and Access.

How can I 'clean' this data in Access so it is uniform?

 

[bubbles]

I export a Access table as a txt file every week to a third party provider
who distributes the file in XML form to online clients. Recently characters
have started to not translate onto sites; usually quotes and apostrophes.I
have been told by the third party service that this is due to a problem from
cutting-and-pasting btw Excel, Word and Access.

How can I 'clean' this data in Access so it is uniform?

You should know that quotes (double quotes) and apostrophes (single
quotes) have special meaning in database query language.

I'd typically replace single quotes ( ' ) with the ( ` ) character,
located at the extreme left of the keyboard (below the ~ character).
I'd replace double quotes ( " ) with the ( ^ ) character.

 

[Sylvain Lafontaine]

I won't be surprised if your apostrophes and quotation marks have been
replaced with some fancy characters by the Autocorrect feature of either
Word, Access or Excel.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[a a r o n . k e m p f]

ADP has MUCH better support for XML than your Jet does

highly reccomend you look into

SELECT *
FROM EMPLOYEES
FOR XML AUTO