>>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]).