>>Naomi I cannot understand the code perhaps I am confusing you - I have given the name town to of one of the fields which has accents
>>
>>Does this make any difference to your code?
>
>No difference to that sample code. Read it till you understand what it's doing. Only after you understand apply the changes you need.
>
>Although I like Michel's code more, it's one simple update command that does the job.
The conversion of an xslx file to a csv file has resulted in invalid characters hence all the problems
Thanks for all your help
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing