Load Excel by Ado get null for numeric data



HI,

I using D7 will Adodataset to read the data from Excel (97-2003) files.

It work fine but when read some number data by

eg. Adodataset1.fieldbyname('tel').Asstring

the Adodataset return null value but the cell has value "23456789"

Would any one can help to get the actual value.

Thanks for your attention.

Remarks the connection string as belows

'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=' + FileName + ';' +
'Extended Properties=Excel 8.0;' +
'Persist Security Info=false;';

Silas


.