After using database odbc to read excel data into a datatable. I am not able to assign [Column value = nothing]

After using database odbc to read excel data into a datatable {Dt1}. I am not able to assign [Column value = nothing]

Example :
Inside for each row in Dt1
{
row(Column_Value)=nothing(null)
}

Error msg:Exception has been thrown by the target of invocation

got the solution:
use row(Column_Value) = dbnull.value

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.