xls values become null [VS2005]

[newdbo]

Hi all, I'm trying to import my xls files to sql server, but i saw some values become null even though data in excel values are existed.
below is my connection string :

        Dim cnstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & txtfName.Text & ";" & _
        "Extended Properties =""Excel 8.0;HDR=YES;IMEX=1"""

i have searched many references about this topic, still no solution.
I changed the registry editor HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
and set the TypeGuessRows become "0", still not give impact to my application.
This error occurs while i'm importing the alphanumeric values into text, but previous values are numeric (but string datatyped).
Any help appreciated!!
THanks in advance

 

[cjard]

I recall someone else complaining about this a long time ago.. A search of the forums might help.

At what stage is your data going missing? what part of the route: file->dataset->sqlserver

 

[newdbo]

It become null from sql server into data reader...

 

[cjard]

That doesnt really make sense, because it implies youre downloading data from sqlserver but your first post implies youre going the other way

 

[newdbo]

Upss, sorry my mistake, it becomes null from excel into datareader...