Hi,
We are reading an Excel file having a column with string values that are sometimes numeric:
406000100
406000200
406000400
406100100
406100400
22900100
22900200
22900300
22900400
22900500
22900600
222900100
222900200
Testing with Squirrel we receive the following values:
406000100
4.060002E8
4.060004E8
4.061001E8
4.061004E8
2.29001E7
2.29002E7
2.29003E7
2.29004E7
2.29005E7
2.29006E7
2.229001E8
2.229002E8
2.229003E8
2.229004E8
We tested both maxScanRows=0 and maxScanRows=1 with the same results.
What can we do?
Tks
PS: I'll send the spreadsheet by email
BTW, we run the following sentence:
select part3, location1, _rowid_ fila
from hoja1
where resultadolocation1 is null
|
|
Supported. Pleased download the latest package.
|
Main
webmaster@hxtt.com