| re: Export unicode to text file
On 23 Jan 2006 19:42:54 -0800, "watto" <watto101@gmail.com> wrote:
You can do it using the FileSystemObject. Note the 3rd argument to the
CreateTextFile method allows you to specify Unicode.
-Tom.
[color=blue]
>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[/color]
| 
