Help: TransferText dropping some characters

  • Thread starter Thread starter A Coyle
  • Start date Start date
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 non-alphabet" characters
(not quite sure how else to describe them), eg the "(r)" character which is
r encapsulated within a circle, or the copyright symbol.

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 the 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
 
Not exactly sure, but you may be dealing with a
Unicode/Code Page difference? Your Access 2K may be using
the Unicode set of characters (32 bit) which can
represent most every character without any messing
around, versus the use of Code Pages (16 bit) in Access
97 which can limit the characters representations.

Don
 
Back
Top