Hi Simon,
The obvious answer is to use a different delimiter, or to enclose the
data values in quotes (as in the classic CSV file, where fields that
contain commas must be enclosed in quotes), or to export it as a fixed
width file.
The other possibility is that this is a character set/code page/encoding
issue. Can you export from Informix to a Unicode text file? That should
avoid the problem, because there's no overlap in Unicode between the
"ASCII" characters (including |) and Chinese characters. (On the other
hand, if your Chinese text really contains the "ASCII" | this won't
solve the problem.
On Thu, 6 Jul 2006 04:58:01 -0700, Simon
<Simon[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >Dear All,
>
>I export a table with delimiter "|" to a text file from Informix database.
>Some fileds include Chinese words. And some Chinese words include "|". It is
>no problem to import it back to Informix.
>
>When I import it with delimiter "|" into Access 2002, it fails because some
>fileds include the delimiter "|". If I remove the delimiter "|" from the text
>file, it casues the Chinese words are not correct. Could you provide me a
>solution?
>
>Thanks,
>Simon
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|