Import date from excel sheet shows blank record

Question

Hi there,

 

I am importing data from excel sheet and inserting into sql server 2008 R2.

 

One column in the excel sheet containing date format, Date format in excel sheet is dd/mm/yyyy.

 

The problem is that when I import date with dd less than 12 (e.g 03/12/2015) then i get blank record after import. 

 

Can we change the date format in the excel before reading it.

 

Reply is appreciable.