Getting 'Smart Quotes' out of Access

[Mark H]

Every week I export a txt file of a table out of Access to a third party
provider who converts it to an XML file for wide distribution and then upload
to various websites such as Amazon. I am having problems with lots of
characters being converted improperly, most significantly the apostrophes and
quotation marks. Is there a way I can 'clean' these out of my database (use a
different font such as Arial Unicode in the table?) or when I export the txt
file?

 

[MyHairIsAlmostGone]

Mark:

The answer I have seems so simple that I may have misunderstood your
question. However, I have the same issue with smart quotes, and Access's
canned Find/Replace works fine for me; I just copy a left smartquote, paste
it in the "Find" box, and put a standard "nonsmart" one in the "replace
with" box. I have done this both inside Access and also in the txt file
(using Notepad or Wordpad). Sometimes I need the smart quotes to still be
viewed as smart quotes on a browser, though, so I have also replaced with
the HTML entities (ie. replace the left smart quotes with “ and the
right ones with ”). I'm sure you could record a macro that would do
both fin/replaces, and just assign that to a button or menu option or
whatever.

Sorry if this is not what you were looking for.

Every week I export a txt file of a table out of Access to a third party
provider who converts it to an XML file for wide distribution and then
upload
to various websites such as Amazon. I am having problems with lots of
characters being converted improperly, most significantly the apostrophes
and
quotation marks. Is there a way I can 'clean' these out of my database
(use a
different font such as Arial Unicode in the table?) or when I export the
txt
file?

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---