ravikumar00008
New Member
Hi All,
i am able to insert the values from excel sheet columns data to the corresponding columns of an sql table.
But the problem is
in my execl sheet i have some date columns.In those some rows are having data(date) and some rows are empty.
Now when i am sending these data to a datetime column of sql table,the rows which are having dates are showing as it is.But the rows which are empty are showing with a default date(1900-01-01 00:00:00.000) in the sql table.
But i need Null instead of 1900-01-01 00:00:00.000.
If i check by inserting the null values from sql.I am getting null values to the date columns.
Note:I didn't use notnull constraint.
Please lt me know how can i achieve like this?
Thanks in advance
Regards
Kumar
i am able to insert the values from excel sheet columns data to the corresponding columns of an sql table.
But the problem is
in my execl sheet i have some date columns.In those some rows are having data(date) and some rows are empty.
Now when i am sending these data to a datetime column of sql table,the rows which are having dates are showing as it is.But the rows which are empty are showing with a default date(1900-01-01 00:00:00.000) in the sql table.
But i need Null instead of 1900-01-01 00:00:00.000.
If i check by inserting the null values from sql.I am getting null values to the date columns.
Note:I didn't use notnull constraint.
Please lt me know how can i achieve like this?
Thanks in advance
Regards
Kumar
