Thank you Naomi
>>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
>
>This problem was discussed here before, check
SQLXMLBulkLoad and empty memo fields Thread #
1380476