i've just noticed that this little annoying character didn't even show in the body of my previous post...
The excel that I uploaded was not the best example as I have now discovered that this problem occurs in CSV files only and also Qlikview will load the recordthat contains this character but will not load any recordsbelow that one. The excel had one record only so it will load anyway.
So in the beginning my load script ended with the following :
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
after ticking 'Ignore End of File' the problem seems to be sorted and the last line should look like that:
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof);