BULK insert not dealing with accented characters

I apologise for raising a question that’s been asked in so many forms before but I’m tearing my hair out…