>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