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!

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.