>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,1Fix #2 on this page worked for me.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer