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

    Unanswered: ADO inconvinience

    Hi,

    I use MDAC2.6-ADO version to connect Text file (CSV formatted) with
    the Microsoft ODBC text driver. Which creates some recordset that contains some missing values.

    For example:

    In a file, a column contains values as follows

    7/2/2001
    abc
    20

    when we geneate recordset the values are as
    7/2/2001
    null
    null

    the value "abc" and "20" are missing in the recordset. For the same
    thing, if i use MDAC2.5 , the values are not missing.
    Can anybody help me in this what would be cause and how to solve?

    Thanks in advance!

    Senthil!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is the actual format of the file ? In the odbc setup, did you go to
    options -> define format and click guess ? Also, ms has a service pack for 2.6.

Posting Permissions

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