>>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]).
----------------------------------
António Tavares Lopes