Hello - I've done a lot of Excel importing into SQL and it's a real pain. Sometimes values simply don't get imported, and other times it makes a guess at the column type which is just wrong, but can't be fixed.

The most painless solution I have found is to save the sheet as a flat file (tab-delimited or whatever) and use the Flat File provider to import. The only thing to watch out for is to ensure your Output Column Widths are big enough on the for the data in the table. It's under 'Advanced' when you choose the data source. If you don't make them big enough the import will fail.

Really, doing it this way has saved a lot of wasted time.

Hope that helps.