Hello, Group.

I use ADODB to retrieve values from excel spreadsheets, and have a problem
when a column's datatype is 5 (numeric) and still the column holds some
character values. The cells having character values are fethced as NULL,
without any error.

Can someone enlighten me on these issues:
- how is the datatype set in Excel?
- can I change it before retrieving the values with ADOdb?
- is there any way within ADO to fecth these irregular cells, or do I need
to use something else?

TIA
Krister

No answer on this - why? If it is out of scope for this group - where would
it be in-scope?



"Krister" <(E-Mail Removed)> skrev i meddelandet
news:S1b2k.8082$(E-Mail Removed)...
> Hello, Group.
>
> I use ADODB to retrieve values from excel spreadsheets, and have a problem
> when a column's datatype is 5 (numeric) and still the column holds some
> character values. The cells having character values are fethced as NULL,
> without any error.
>
> Can someone enlighten me on these issues:
> - how is the datatype set in Excel?
> - can I change it before retrieving the values with ADOdb?
> - is there any way within ADO to fecth these irregular cells, or do I need
> to use something else?
>
> TIA
> Krister