>>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.
>


Thanks for the advice, but this approach has become quite impracticle, especially with memo fields and attachments. Got it to work, but its VERY slow and quite sloppy