Load Excel by Ado get null for numeric data
- From: "Silas" <silas01@xxxxxxxxxxxxxx>
- Date: Thu, 28 Feb 2008 23:26:03 +0800
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
.
- Prev by Date: Re: Dll Project with ADO
- Next by Date: Reconnect does not work TADOconnection
- Previous by thread: Dll Project with ADO
- Next by thread: Reconnect does not work TADOconnection
- Index(es):