>The data needs to be appended from one table into the second.

Ellen,

Make the second table have both the character field and the memo field that you want. Append from the first into the second. Then REPLACE ALL CharacterFld WITH MemoFld to move the memo data into the character field. Finally modify the new table and remove the memo field from its structure.