A
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
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