Help: TransferText dropping special characters

[A Coyle]

Hi

Running a database developed in A2000 but converted to
A97. A97 database
running on Win98.

I have a query which has fields containing "special"
characters, eg the (r)
character which is r encapsulated within a circle, plus
other similar "special" characters

If I export (to csv) from the database window
tables/queries containing
these characters they are exported correctly, the
characters appear in the
resulting csv file.
If however I export these exact same queries from VB,
using TransferText
they are not exported (eg the (r) character turns into a
plain r). I am not
using any predefined export spec, just blank (default).

Does anyone know what is happening, and/or how to rectify
the problem?
The problem is not present in A2000, just the A97
converted database.

Thanks in advance
A

 

[Dev Ashish]

Does anyone know what is happening, and/or how to rectify
the problem?

See if this addresses your problem

[ http://support.microsoft.com/default.aspx?scid=kb;en-us;308686 ]

-- Dev