"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."
I agree on that. The situation described has been on the agenda many times. I woudn't use any
wizard but for a flat tabseparated texfile. I would either split the 10 worksheets to 10 textfiles and
import them (by a macro) or write plain VBA SQL code (insert) which loops the sheets.
You can take a look at :
http://support.microsoft.com/kb/321686 (an old one)
/Gosta