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

Thanks for your advice.. I think SQL Server considers "" as NULL...this would be a definite problem!