>>>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.
>>
>
>
>Good point. I look into this. Still doesn't make sense why that would fail but the INSERT INTO for each records doesn't. It said ID cannot be null..well, there are no NULL ID's in my VFP table! A bit strange.
>
>Thnnk you!
>- GM


Gino

Try selecting NULL (When checked, specifies that the field can accept a null value.) for each field in your table before you execute the APPEND FROM to the view. I had a similar problem with Remote Views in VFP.

MOnTe