Hi Aaron,

>I'm trying to copy data from tables that are currently being used in a program written in Clipper to new tables created with VFP. A few tables have larger than 254 size character fields (most are 1024) which VFP changes the size to 0, which causes the data to "bleed" into other fields and corrupts the table.

Don't append right into the target table. Instead create an intermediate cursor where each of this 1024 fields is splitted into 5 smaller fields and append into that cursor. Then loop through the cursor and copy all records into the actual target table. If the Clipper program really uses more than 254 characters in one field, you have to make it a memo field.

Christof