Loading

Insert null if row is empty in excel

rachayita jaiswal

12y1.1k.NET

Hi,

I am uploading excel sheet and storing data in database table.

Some of data in rows is empty so how to insert "null" in place of empty data in database?/

Please help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

rachayita jaiswal12y ago
hi,

I am not facing any issue .
in my database it is inserting as blank only but I want to inset 0 if any data is empty in excel ....
R J12y ago
how you are reading the excel, can you place your code where your getting exception or issue.