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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
