Problem while reading excel file with mix datatypes

Discussion in 'ASP .Net' started by =?Utf-8?B?UGF1cmF2aQ==?=, Mar 2, 2004.

  1. Hii

    I am reading one excel file that has one column with numbers and text in it

    I am reading excel file using oledb with connection string a

    Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" &
    "Data Source=" & fileName & "; Extended Properties=Excel 8.0;

    now using DataReader i m reading one column that has data a
    0.03,0.04,aa,0.0

    But while printing i m not getting value "aa"...Why So

    Kindly help me to solve thi

    Thank
    Pauravi
     
    =?Utf-8?B?UGF1cmF2aQ==?=, Mar 2, 2004
    #1
    1. Advertising

  2. Your post went unanswered. Have you resolved this issue?

    --
    Regards,
    Alvin Bruney [ASP.NET MVP]
    Got tidbits? Get it here...
    http://tinyurl.com/3he3b
    "Pauravi" <> wrote in message
    news:...
    > Hii
    >
    > I am reading one excel file that has one column with numbers and text in

    it.
    >
    > I am reading excel file using oledb with connection string as
    >
    > Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    > "Data Source=" & fileName & "; Extended

    Properties=Excel 8.0;"
    >
    > now using DataReader i m reading one column that has data as
    > 0.03,0.04,aa,0.05
    >
    > But while printing i m not getting value "aa"...Why So?
    >
    > Kindly help me to solve this
    >
    > Thanks
    > Pauravi
     
    Alvin Bruney [MVP], Mar 4, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gomathi

    Problem while reading from excel

    Gomathi, Feb 13, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    469
    Gomathi
    Feb 13, 2006
  2. john smith

    mix mode file reading/writing?

    john smith, Jul 29, 2003, in forum: C++
    Replies:
    4
    Views:
    377
    Thomas Matthews
    Jul 30, 2003
  3. pps!
    Replies:
    0
    Views:
    1,044
  4. aeonsun
    Replies:
    2
    Views:
    437
    Luc The Perverse
    Mar 11, 2007
  5. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,548
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
Loading...

Share This Page