If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help! Character Encoding Problem when exporting from Access to XML
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? |
#2
|
|||
|
|||
Help! Character Encoding Problem when exporting from Access toXML
On May 11, 5:31*am, Mark H wrote:
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. |
#3
|
|||
|
|||
Help! Character Encoding Problem when exporting from Access to XML
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) "Mark H" wrote in message ... 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? |
#4
|
|||
|
|||
Help! Character Encoding Problem when exporting from Access toXML
ADP has MUCH better support for XML than your Jet does
highly reccomend you look into SELECT * FROM EMPLOYEES FOR XML AUTO On May 10, 11:42*pm, "Sylvain Lafontaine" wrote: 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) "Mark H" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|