I agree with david the importing from excel is bad at best

Pretty bad considering they are both microsoft products

I always go to csv files to import

Although MS screwed that up also with sql2005

I had several CSV imports that worked sql2000 but failed in sql2005 and sql 2008