PDA

View Full Version : ADO inconvinience


sendakil
05-22-02, 00:47
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!

rnealejr
05-22-02, 23:30
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.