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

If you need to end up with 2 tables, what you want to do will work. Or, for that matter looping thru and updating one at a time as I suggested. What Jim is talking about is the ability to just work with one table if one table is the only result you are looking for. If you want to end up with just one table and not two, this will do it.

ALTER TABLE mytable ADD COLUMN charfield C(25) && this adds a character field (you can make the character field the length you need) and retains the memo field

REPLACE ALL charfield WITH memofield && this will take the contents of the memo field and place them into the correct character field

ALTER TABLE mytable DROP COLUMN memofield && you now have a table whith no memo field, but the data that used to be in the memo is now in the character field.