Even if field names are the same, you cannot append a character field (from one table) to another table with a memo field. Given.the example:

Append From SomeTable Field LongString

If LongString is type "C" in the source, and Type "M" in the currently open table, no data is appended.