Further information on teh above.
1. The query does not have any group by clause.
2. The only manipulation with the memo field is the prefixing with text "Error:" when the description in both input files do not match.
3. when i change the cell format in excel to "General" teh problem still appears.
If changed to "Text" then i see ###########