read data from excel and write into dbf (local language prob

[apichit]

Hi all,
Help me please!
I wrote a small program to read data from excel and write into dbf file. I have problem about my local language. Customer Name in excel sheet is in my local language (Thai), when program read and write into dbf it show ???????? in customer name in dbf.

[mol]

I've tried your sample, I've got something like that in Excel:


Is it right?

You must remember to include file:

Code: Select all

#include "hbextcdp.ch"

to properly use codepages with excel and openoffice
and set codepage, eg:

Code: Select all

	HB_CDPSELECT("PLWIN")

Regards, Marek

[apichit]

Hi Marek,

Thank you very much for your help.
In excel is source data, it show correct customer name, but in dbf file, it shows ??? ? ??? in Customer name.

Regards, Apichit

[mol]

What is your souce language?

[apichit]

Thai (Thailand)

[mol]

What is your codepage?

[apichit]

I have no idea about code page in HMG but I check from my Firefox, it has 2 as list below:
Thai(windows-874)
Thai(TIS-620)