>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