posted 23 years ago
Does anyone know how to get around this problem?
I can connect to an Excel document, and read data from it.
However, I have a big problem: if a column contains a mixture of numeric and alphanumeric data, some of the cells return a null value.
If the first cell contains a number, even though I've formatted the cell as text, it is interpreted as a number (a double, to be precise.)
Then, when the program hits the first cell containing letters as well as numbers, it returns a null value.
If we can fix this, we will be happy as Happy Jack McHappy, Outright Winner of the All-England Happy Championships.
All ideas welcome
TIA
Jay