Need Urgent Help!

I imported xl spreadsheet data into sql server. Some data is converted with
<NULL> value even though the data exists in the xl spreadsheet column.
The funny part is it is not <NULL> for the entire column. For eg. I have a
column called 'Part Number' , some rows have the correct 'Part Number'
whereas others have the 'NULL' value, even though the Part Number is not nul
l.
This happens for a few columns.
I already tried converting problem column formatting to text or numeric, but
it didn't make any difference.
Does someone have any idea why it must be happening and how I can import all
data.
Thank you in advance,
-Mehttp://www.sqldts.com/default.aspx?254
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Me" <Me@.discussions.microsoft.com> wrote in message
news:B059ABB1-DF2B-44AE-BAC8-52343F72EDB7@.microsoft.com...
>I imported xl spreadsheet data into sql server. Some data is converted with
> <NULL> value even though the data exists in the xl spreadsheet column.
> The funny part is it is not <NULL> for the entire column. For eg. I have a
> column called 'Part Number' , some rows have the correct 'Part Number'
> whereas others have the 'NULL' value, even though the Part Number is not
> null.
> This happens for a few columns.
> I already tried converting problem column formatting to text or numeric,
> but
> it didn't make any difference.
> Does someone have any idea why it must be happening and how I can import
> all
> data.
> Thank you in advance,
> -Me
>