Handling NULL Values RRS feed

  • Question

  • Hi Friends

    I'm importing data from Excel sheet. I have a date column in the excel sheet and where ever the date format is not correct the value is showing as NULL when I import the data.

    I tried changing output to VARCHAR and also tried IMEX=1 in excel connection string, still the problem exists.

    Royal Thomas

    Friday, January 25, 2013 8:41 AM