Export unicode to text file

[watto]

We have a rather large application built around Access 2k3 which will
soon be used for a project in China. The data is exported into CSV
files for use by another application. We are just learning that
exporting the Chinese text (unicode data) is not as straight forward as
we had hoped. We can enter the Chinese on the forms and it is stored in
the tables, but is converted to ??? when exported using Print
functions.

There is a lot of manipulation of the data in code so it is not
possible to simply dump the table using OutputTo (which can output the
unicode if used from a macro). An attempt using Put to a binary file
didn't seem to work.

Any ideas on how/if this can be done?

cheers
Andrew

[Tom van Stiphout]

On 23 Jan 2006 19:42:54 -0800, "watto" <wa******@gmail.com> wrote:

You can do it using the FileSystemObject. Note the 3rd argument to the
CreateTextFile method allows you to specify Unicode.

-Tom.

We have a rather large application built around Access 2k3 which will
soon be used for a project in China. The data is exported into CSV
files for use by another application. We are just learning that
exporting the Chinese text (unicode data) is not as straight forward as
we had hoped. We can enter the Chinese on the forms and it is stored in
the tables, but is converted to ??? when exported using Print
functions.

There is a lot of manipulation of the data in code so it is not
possible to simply dump the table using OutputTo (which can output the
unicode if used from a macro). An attempt using Put to a binary file
didn't seem to work.

Any ideas on how/if this can be done?

cheers
Andrew