importing Null values while importing data in SQL server

[andypower]

Hi guies

Thanks in advance....
I'm using MS SQL 7's DTS Import wizard to import the Data from Excel. Now the problem is, there one col in a excel which contains a some numeric data and Alpha numeric data.

now if i imported that excel into the SQL server it is placing NULL values either in place of Numeric Data or Alpha numeric data, even if the Data is present into the Excel
Please Help me out.....

 

[rac2]

Sort of depends on why the column has some numeric and some alphanumeric.

If the data all represents numbers, but some cells happen to storing strings, then you might transform the data in the spreadsheet into all numeric before doing the import. There may be functions in Excel to convert strings to numbers, or you might simply edit the cells manually.

If the data actually consists of numbers and non-numbers, then you will need to do the import in two stages, one for the numbers and one for the strings. A database column may store only one type of data. You must place the numbers in one column and the strings in a different column.