You need to change the connection properties of Excel connection to support mixed types.
Modify the excel connection string and add IMEX=1 to the extended properties.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";