"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