I experimented with various options and the one which worked was by specifying ROWTERMINATOR='char(10)'.

CHAR(10) equates to the Line Feed character.

Many thanks for your help.

I experimented with various suggested options and the one which worked was by specifying ROWTERMINATOR='char(10)'.

CHAR(10) equates to the Line Feed character. Only the t, n, r, \, and 0...