Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Codepage,appending from excel
Message
 
To
15/12/1999 01:09:12
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00303154
Message ID:
00304005
Views:
28
>>>Iam trying to append from excel, latvian characters included.
>>>Everything is fine in excel, but when i append to vfp(using codepage 1257) some charactes is different....
>>>ui etc.
>>
>>Hi Ismo,
>>I assume your Windows default codepage is 1257 (Baltic). Did you check your DBF codepage, if by any chance it is different? Do you use CPCONVERT anywhere? How do you append the data from Excel?
>>
>>Nick
>My windows default codepage is 1252,i used cpzero to make my dbf codepage to 1257.I dont use cpconvert.I used append from excel,import from excel,import wizard and even i tried 'save as from excel to dbf;dbase4....But is it
>cpconvert?

Yes, in this case you need to use CPCONVERT(1252,1257, myfield) for all your character fields which can contain text.

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform