Re: Excel data problems

Yipee, that worked just fine, thanks!!!, been banging my head against
the wall for a while on that one :(

Regards

DGJ


On Thu, 23 Nov 2006 14:37:02 +0100, "treok" <h.k.j.keesmaat@xxxxxxxxx>
wrote:

Hi

I am hooking up an Excel spread*** to an ADO dataset then processing
the records to update an SQL server. This works just fine, except when
some of the first fields in the column contain numbers. i.e.


ConnectionString :
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended
Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

"HDR=Yes;" indicates that the first row contains columnnames, not
data. "HDR=No;" indicates the opposite.

"IMEX=1;" tells the driver to always read "intermixed" data columns as
text. Note that this option might affect excel *** write access negative.



--- posted by geoForum on http://delphi.newswhat.com
.

Quantcast