>>I usually use copy and paste, but there's an Export Data under Database/Tasks that I've also used occasionally.
>>I've never tried what you're trying, but it might be worth a look.
>
>Surrounding with CHAR(34) is a way to do this :
>
>CHAR(34)+'Hello'+CHAR(10)+'World'+CHAR(34)
>
>However, doing this does not :
>
>CHAR(34)+Table.Field+CHAR(34)
>
>...nor this :
>
>CHAR(34)+REPLACE(Table.Field,CHAR(13),'')+CHAR(34)
>
>...nor this :
>
>CHAR(34)+REPLACE(Table.Field,CHAR(13)+CHAR(10),CHAR(10))+CHAR(34)

That's interesting.
I tried some searching but I can't find anything about what Type 'Hello' is.
I assume it's CHAR() but if it works where other CHAR() don't, I wonder.