I have an excel sheet with columns Name and Date.
When I am using excel loop to read the data and insert data into DB, and if the Date column is empty in a row, date is inserting in DB as 01/01/0001 instead of null.
When I am trying to convert that excel to datatable using import Datatable instead of excel loop date is displaying as 30/12/1899 instead of empty.
Please let me know how to add empty row for datetime if the column is empty.
Below is the excel :