>>>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