Yes there is. You can set the TypeGuessRows registry property to change the amount of sample rows.
(the default is 8 by the way, not 10).
More information:
What’s the deal with Excel & SSIS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP