How to check data while importing Excel using office integration pack?

Jan 8, 2013 at 8:28 AM

How to check data while importing Excel using office integration pack?

I have made one choice list....for blood group

In database i m using integer data type ..everything is going fine.....

but if I import any excel having blood group field values like A+, O-...

so it gives error "cannot convert string to int16"

please help me for implement this in columnmapping or in any?