>For several days I've been trying to find an easy way to dump my FoxPro table(s) onto our MS SQL Server programatically (without using the Upsizing Wizard). I was curious how the rest of the FoxPro community was doing this.
>
>APPEND FROM into a remote view didn't seem to work; only kept first 200 records. Please help!

Gino,

Are you sure that your VFP table doesn't have any data that breaks rules in the SQL Server Table? APPEND FROM should work fine.

HTH