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

And that is probably the one that didn't have a problem. BTW, sql server can't handle empty date fields unless you allow null values. So if your not allowing null, you MUST choose a value you consider to be empty to put into the field.