>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
If it's not broken, fix it until it is.
My Blog