How to import unicode csv file.

[charles]

We use B8.93 as400 version(V5R3).When we run ube and export to CSV file we can get a unicode csv file(file include JAPANESE character). It is display correct in NotePad. But if we use excel open the csv file it will be corrupted.

How to solve the problem?

 

[Adrian_Chimirel]

Has Excel been installed with Japanese language?

 

[charles]

Yes.

 

[Adrian_Chimirel]

I have two suggestions:

1 - See if jdetechie07 solution applies to your UBE - it has to be setup in P98301 - see thread
http://www.jdelist.com/ubb/showthreaded.php?Cat=0&Number=83313&page=0&view=collapsed&sb=5&o=14&vc=1

2 - Are you able to properly save as csv from your Excel?

Warm regards,