>Not too wierd, just working as advertised. The column is tagged as not null on SQL so every row must have a value in the VFP table in the column to be inserted into SQL.
>
>Also, I would be careful about calling a column just 'DATE' as things like Oracle and SQL are much more unforgiving about reserved words.
>
>PF
>
>>
>>I am now getting invalid Insert erros , one of my columns named Date, it says it can not accept nulls values, weird since it has only appended only a row into SQL , in my FoxProtable I have about 100 rows.

Hey and you are correct my friend, ;-), it is only kind of extrange that
only the first row will get commiteed into SQL, when there is 99 more to go