>>>Just change your regional settings to support arabic (Non-Unicode Applications) and import all strings from Excel to Char or Memo Binary fields.
>>
>>The strings are already loaded into Char fields. Are you sure changing regional settings would be enough? I don't want to change my settings, but I suppose that Mohammad already have set them this way.
>>
>>BTW, one minor fix to my program: I need to import only first 254 columns, otherwise there would be a problem with the table.
>
>Usualy this is enough, but sometimes I have problems when Importing from Excel and don't use automation. All cyrillic letters becomes a mess :o))
Yes, I understand. Do you have some ideas how should I fix my program (in the first message) to correctly set table's code page if I encounter non-standard characters in the fields? Also does it mean I have to read each cell value trying to determine its character set?
For myself I don't have the problem since I'm dealing with English in Excel only. But since I received about 5 e-mails from Mohammad and had to deal with that Excel, I want the program to be robust enough to handle various languages.
Thanks again.
If it's not broken, fix it until it is.
My Blog