>>>Here is an example of a select which converts into some of that:
>>>
>>>
>>>SELECT Member.Numero
>>> FROM Member
>>> WHERE Member.NoCountry=1 AND Member.NoProvince=2 AND
>>> CHRTRAN(Member.City,"ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ","AAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy")
>>> ORDER BY Member.LastName,Member.FirstName
>>>
>>
>>My problem is caused by converting am xls file to a csv file before appending to a table - that corrupts the accents
>>
>>How can I import or append the xls to a table without creating a csv first
>>
>>Colin
>
>It's not corrupting the accents, it's exporting the data using codepage 850. Either you export to ANSI, or after data import you CPCONVERT(850,1252,[your data]).
How do I export to ansi?
Is cpcconvert a vfp function?
Thanks for your help
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing