Powershell Invoke-Sqlcmd Replacing £ with?
I managed to test that the text file may have been the issue. When I opened up the text file and changed the encoding to Unicode, the £ and the € were inserted into the databsase.