Hi all. I have to use the TransferText method to import large amounts of
DOS text into Access on a daily basis, and I'm having to include characters
with accents (grave, circumflex, umlaut, etc). My DOS prog creates the
characters without a problem, but Access misinterprets them as commas and
such. How can I make Access read in the actual accented character?

Thanks,
Jon

--
Remove "bug" from address to reply.

"Jon Weston" <jwes (AT) shaw (DOT) net> wrote

Hello Jon,

I guess one of the first questions I would ask is,
do your DOS text files have Fixed Length fields or
are they delimited records like comma or tab or, etc.?

As a suggestion,

1. If they are Fixed Length, set up an Access import spec
to handle the data AND set the fields to text.

2. If delimited, do the same, set up an import spec and set
the fields to Text, in the import spec after it has been made,
so that the data shouldn't be lost or changed.

Good luck.

Ray