>>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!
>
>Have you tried using SQL Pass-through? You could loop through all the records in the table and insert them one at a time. A little brute force, but it should work.
>
>HTH

Also, the last mean (although APPEND and pass-through should work) is to export data to text file, and import it to SQL-Server manually.