Donald
Just a shoot in the dark. Did you try to copy the table to a new temp. table from within VFP, then run the APPEND from the temp. table?
Jaime

>Good afternoon
>
>I am moving records from a Clipper DOS application to VFP. While using
> SELECT TargetTable
> APPEND FROM SourceTable
>the table data appends fine, until we process a table with more than 500,000 records. On this table, VFP does not copy any records, nor does it return an error message, just seems to skip over the append command.
>
>I have it working with a Scatter to memvar, Insert inside a SCAN..ENDSCAN loop.
>
>But I would like to know why the APPEND failed? Is there a file size limit on Appending table records? Note that this is not an append from Excel or on of the other documented exceptions.
>
>Using VFP7/SP1. Clipper tables and VFP tables have identical fields, field length, etc.
>For good measure I preprocess the Clipper tables to have a DOS 437 code page, open and close the tables, compare structures, etc. (natively, Clipper tables do not have a code page flagged). Indexes are not involved, because the VFP tables have different indexes, so this is a straight APPEND FROM without any conditions.
>
>Thanks in advance for scratching my curiosity itch.
>
>Don Lowrey