I apologize for the previous post. It turns out that it was just a display limitation in the query analyzer. After bringing the data back into Fox, I verified that the data was not truncated.

>I'm trying to use a Bulk Insert on a memo field.
>I've hand coded the building of the text file because COPY TO will not copy memo fields.
>I've modified the field terminator and row terminator but I need to bring in character fields as varchar that are greater than 256 characters.
>
>This seems to be a limitation.
>
>I've built a script and which I've added below.
>
>What is the work around for this problem?
>
>TIA
>
>
>