>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.

Laterness,
Jon