I imported an xl spreadsheet data into sql server database. I notice that
some columns data is NULL even though the data exists in spreadsheet.
However, the entire columns isn't null, some columns it converts correctly
whereas for others it puts <NULL. I tried converting the column into both
text and numeric fields, but I got same results. This is happening for a few
columns, some columns have been converted correctly.

Any ideas as to why it may be happening? How can I fix this?

I need to fix this asap as I have project deadline to meet.

If this is not the right group for this question, please let me know.

Thank you very much,
-Me

If you have numeric and text data in the same column, you may find that the
values will be returned as NULL. Normally, you would have only one value type
in a "field" (column).

P.

"Me" wrote:

I imported an xl spreadsheet data into sql server database. I notice that
some columns data is NULL even though the data exists in spreadsheet.
However, the entire columns isn't null, some columns it converts correctly
whereas for others it puts <NULL. I tried converting the column into both
text and numeric fields, but I got same results. This is happening for a few
columns, some columns have been converted correctly.

Any ideas as to why it may be happening? How can I fix this?

I need to fix this asap as I have project deadline to meet.

If this is not the right group for this question, please let me know.

Thank you very much,
-Me