Excel data problems

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.

Node Name
******************
aa1 1
aa2 1
aa3 2
aa4 2
aa5 James
aa6 Peter
aa7 Tommy
aa8 Sandra
aa9 David // About 50 more

The first column imports OK but the second column only imports the
numbers and exludes any of the names I can fix this to a certain
extent by increasing the MaxScanRows setting to 16, this now imports
all the names but not the numbers.

I know now that the Jet engine scans the first 8 fields to try and
determine the data type, obviously if this is increased it will get
more "text" hits and set the type accordingly.

Is there some way I can import both numeric and text data?

Any help would be appreciated

Thanks

DGJ
.

Quantcast