Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Malaysia
    Posts
    18

    Unanswered: ADO rs for EXCEL file - Missing numeric data

    Hi,

    I created a ADO (MDAC2.5) recordset for Ms-excel file using ODBC driver. The file contains columns as follows

    A b
    ------------------------
    End Date: 08/07/2001
    SI BQ
    -27 67
    -27 67
    -25 25
    -18 20
    -68 13
    -30 13
    -27 67
    -222 272
    -------------------------------

    The column A has character type of data "End Date" and "SI" and
    Numeri type of data "-27,-27,-25,etc.". What happened when i created
    recordset for this file, all numeric type of data missed in that recordset.
    please, Anyone can help me what would be the cause and how to solve this.

    Thanks in advance

    regards
    senthil

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    Sendalkil-

    The problem is with the Excel ISAM. Unfortunately, it's been a while since I had to deal with this problem, so I can only give you some pointers. Excel ISAM reads the first 8 rows of data (value specified in System Registry) and determines the data type ... but when there are more than two types, it kinda goes crazy, and fills the recordset with nulls.

    The answer is in Microsoft's Knowledgebase

  3. #3
    Join Date
    Oct 2004
    Posts
    1

    Can't find solution in Knowledge Base...

    I'm having the same problem that Sendakil described with Excel losing numeric data when retrieving the data via ADO. I can't find any knowledge base articles about this. Does anyone have any tips on resolving this problem?

    Thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •