Connecting Tech Pros Worldwide Help | Site Map

Export unicode to text file

  #1  
Old January 24th, 2006, 03:55 AM
watto
Guest
 
Posts: n/a
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

  #2  
Old January 24th, 2006, 02:05 PM
Tom van Stiphout
Guest
 
Posts: n/a

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]

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting unicode characters to a file (at this point I dont carewhat type of file) JimmyKoolPantz answers 2 July 22nd, 2008 08:15 PM
Access Table to text file (CSV, Tab, etc). Is there an easy way to do this? Irene answers 8 July 9th, 2008 07:05 AM
Problem with export of a table to a text file Daniel Wetzler answers 3 August 24th, 2006 03:55 PM
DataSet to Text File scorpion53061 answers 11 November 20th, 2005 12:45 PM