>Hi all, i just need to make an append from xfile, but my target table has a memo field in the position email, so if i use append from xfile only, this field doesn't be filled.
>Somebody knows how to fix this? i need to use the memo field because the column mail can be longer than 254 chars.
>
>thank you all.

try

INSERT INTO (ALIAS()) SELECT ... FROM xfile