-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Nilesh
Message 3 in Discussion
hi all ,
this is in regards to my question of reading thru excel
i am using it in a web application..
the connection is
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & excel_path & ";Extended
Properties='Excel 8.0;HDR=YES';
and the adapter is
OleDbDataAdapter("SELECT * FROM [pol$]", strConn)
i fill the dataset with this
the excel file has a column name policy_id
and multiple rows Policy_Number
123Man1
123Jan2
123Tan3
234Kan323
sdf23fd
wer2433sd
45fghfgh
2323
in the above example the last "2323" is a numeric value and thats the one
which does not come in the dataset ..
i check the dataset for the value for that particular row it shows null..
but it shows the values of the other columns for that particular row....
regards
nilesh
_________________________________________________________________
Xerox Multifunction devices�that print,copy,scan and fax.
http://go.msnserver.com/IN/44797.asp Get affordable printing solutions that
fit your needs .
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
