Believe it or not, this is the standard/default behaviour of the Excel provider.

Have a look at http://support.microsoft.com/kb/189897 - it tells you of the registry change that you can use for modify the number of rows that are used to determine the length of the column.