Conversion from long to varchar

Hello, 

I'm exporting my tables from Access 97 to SAPDB. Now I have the following
problem: In my Access tables sometimes I use the Memo-Datatype. If I export
these tables to SAPDB these fields get converted to the long datatype. Now I
want to fill my new created tables in SAPDB with the entries from the
exported Access tables through a 'Insert into'. In my new created tables
there are no long-datatypes, for these  fields I've used varchar(<size >=
1000>). Now these 'insert into' fail, because SAPDB can't convert long to
varchar, even if th varchar size is big enough for the real content of the
long field.
Is there maybe a possible conversion function (like Date() for a Timestamp
-> Date conversion) I can use, that I've missed or is there some other way?

Btw the content of the Memofields is only text, but sometimes more than 255
characters long (if this would not be the case, I had used the usual text
datatype from Access).

Thanks in advance
Peter Huebschen