Hi,

I have just tried create the table as you said then fill the data adapter but got exact same error 'the given value of type String from the data source cannot be converted to type nvarchar of the specified target column.'

Is there anyway to find out exactly which column is causing this error, as said there is around 200 columns.

could it be an issue with NULLs