>>>>>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
>
>CPCONVERT() is a VFP function.
>
>Can't help you with Export settings, don't use Excel myself (but LibreOffice has the option to set character encoding for writing to CSV files, so I'll assume Excel has it also in its Save As... command).
Thanks
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing