Hi All.
I am trying to use SQLXMLBulkLoad example posted by Doug Henning to create a bulk upload from VFP into SQL server.
In my SQL Server structure I do not allow NULL values for any of my fields, except DateTime fields.
During upload if a table has any character fields with no values, the upload will fail and the error message says

"OLE IDispatch exception code 0 from General operational error: No data was provided for column 'columnname' on table 'tablename', and this column cannot contain NULL values..."
Any suggestions how to work around it?


Thank you
Yelena