Excel Spread***, Blank field values when HDR=Yes

Hello,

I am using Delphi 7 with ADO, tested on any Windows version. And I am
opening an Excel spread*** in ADO and viewing it in a table. If I do
*not* specify that the first line contains field names (no field names in
first line), then the data in the table displays correctly; all fields and
all rows contain the data they should. But if I specify that the first line
contains field names by adding "HDR=Yes" to the ConnectionString, then some
cells have missing data.

The column with the missing data combines Float and String. The first cells
in the column are Floating point values. Further down, there are String
values. Here is an example:

HDR=No HDR=Yes
-----------------------------------
0.04 0.04
0.039 0.039
0.038 0.038
0.041 0.041
TRUE
TRUE
FALSE
TRUE
3.9 3.9
3.8 3.8

If HDR=Yes, then the TRUE and FALSE text disappears (in the foregoing
example). This looks a lot like the behavior of the "IMEX=1" switch, but I
don't expect this kind of behavior with the "HDR=Yes" switch.

Is there a way to indicate that the "first line contains field names" and
still have all of my data too?

Byron Upchurch



.

Quantcast