import issue

I am importing an excel file into the DB and one of the column in the excel sheet has the data shown below.

1111
2222
nnnnn
llll
3kkk
4fff
yyyy
xxxx

WHen i import this data i could not get the data nnnnn,llll,yyyy,xxxx into my db.

And after few attemts i found that if i have the first element in the list start with an alphabet its importing all the information start with alphabets(nnnnn,llll,yyyy,xxxx).
If the first element in the list start with a numeric value its only importing the following values(1111,2222,3kkk,4fff).
But how can i import all the records into my DB.

Thanks.What are you using to perform the import? DTS?|||yes i am using DTS.|||DAMN...another reason to not use DTS...

I Just went through that with someone else...it loads them as null, right?

I'd say bcp

What the layout of the file?|||The simplest answer is to export to a text file, then import that text file using DTS. See KB#236605 (http://support.microsoft.com/default.aspx?scid=kb;en-us;236605) for more explanation. The problem lies in how DTS attempts to process mixed rows (some text, some numeric cells), where if you convert everyting to text it becomes a non-issue!

-PatP