I'm a rookie VB developer. I have to read some data from the Database which happens to be in Japanese language. I have to get this data and put it into another DB on my local machine. I run english version of Win OS.While i try to read the data, what i get back is merely ?????, ie junk data. When i try to do the same in Java, i have no problem, the data looks fine(it is inserted properly). But when i try doing it thru VBA (i use VB macros, my front end is Excel), i end up inserting only ????? in the Access(Local DB).
To avoid this, i'm forced to get the ASCII eqvlnt of each literal of the data. This is causing a lot of delay in the operation.
Can someone suggest a better way to do this?