>>>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
It's a problem with Excel, that it doesn't give you the option, when exporting into csv, to pick a codepage. LibreOffice does, so perhaps download and install that. It's been some thirteen years since I last had M$ Office on my machine (and even then it was because of a client, who was supposed to pay for that) - it keeps adding features I don't need and removing the ones I do.