PDA

View Full Version : ADO rs for EXCEL file - Missing numeric data

sendakil
05-17-02, 06:06
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
vududoc
05-17-02, 12:05
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
Kimba522
10-06-04, 15:37
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.