I've done this so many times before and never faced such a problem. but today i tried to import the data to sql server 2012 from excel 2010. all the sudden i realized that half of the date values did not imported and are null in database. I've done this so many times before and never f