468,290 Members | 1,849 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,290 developers. It's quick & easy.

Export unicode to text file

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

Jan 24 '06 #1
1 2889
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


Jan 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ted Theodoropoulos | last post: by
1 post views Thread by Kevin Blakeley | last post: by
3 posts views Thread by nologin | last post: by
12 posts views Thread by =?Utf-8?B?YXVsZGg=?= | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.