>>
>>You can not put data into the Memo field with this command AFAIK. Make this field to be character.
>
>I have to find a way to import into a Memo field. The example I showed has a short text. But some tables have very long text in one of the columns so it only can go to Memo field. I guess I will have to write a program to parse the .txt file and "manually" insert records.
>
>Thank you.

This may help

http://support.microsoft.com/kb/140294