>>I did a quick DST using an excel price sheet and found allot of nulls
>>when I have a column general in the sheet having ONLY a numeric value.
>
>Stephen,
>
>Unfortunately, this is a common problem due to the Excel driver's guessing the data type based on 8 rows of data. I found this web page to be extremely useful in dealing with the issue:
>
>http://www.sqldts.com/default.aspx?6,222,254,0,1
>
>Fix #2 on this page worked for me.


Bingo!

Thanks alot.

__Stephen