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.