Like I said previously, I cannot change the database to accept nulls. Isn't there a way, like in VFP when you execute a SET NULL OFF command, to do the same with the VFP OLE DB provider so the database will not try to insert nulls into my table? Because if I issue that command in VFP with NULL set OFF it will not try to insert nulls into my table, it will just default the values accroding to whatever type they are. I understand that I am trying to insert into a field that does not accept nulls and the table isn't set up to do that and it is not the OLE DB provider that is the problem. However, like in VFP where I can set NULL OFF, is there a way to do that with the OLE DB provider? If not, how can I issue an insert statement using the VFP OLE DB provider to insert a blank value into a VFP general field without having to use APPEND GENERAL?