Daniel:
For each Excel column that had some fields with more than 255 characters, I moved one of these "offending" rows into the first 8 rows of the spreadsheet and then reran the DTS package. All 868 rows then imported without a hitch.
Many thanks.
GOdfrey
Godfrey Nicholson
Ofek Technologies Ltd
Auckland
New Zealand