Just to add a little more detail to this. After much fiddling I managed to get the data to import to the load table. This is how it's being imported...

Thanks to everyone who posted. It's nice to know I'm not going mad, and it is an odd file format 🙂

Hopefully they'll be able to change format and I won't...

Hi John,

Yeah, I have thought about doing some pre-processing to convert the file to | or TAB delimeted. I just can't believe it doesn't work straight out of the tin.

I've...

Hi John,

Thanks for the reply.

I've tried that. It just pushes the problem on. It seems that if I do that when it gets to the next numeric field it's trying...