Datatypes

K

Krister

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
 
K

Krister

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation, mandatory and restricted field length for excel vbs 10
Start/End Cells in a Range 2
Working with tables in Excel 2007. 2
Copy only nonblank cells 8
Text Formats 4
Formatting Cells - Hex Values 3
how to get excel to calculate from ASP? 2
how to compare formula's values? 4

Top