PC Review


Reply
 
 
Krister
Guest
Posts: n/a
 
      6th Jun 2008
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

 
Reply With Quote
 
 
 
 
Krister
Guest
Posts: n/a
 
      9th Jun 2008
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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Datatypes Harry-Wishes Microsoft Access External Data 1 30th May 2008 11:08 PM
how to map datatypes... =?Utf-8?B?bGlnaHRfd3Q=?= Microsoft C# .NET 3 15th Nov 2006 06:18 PM
datatypes =?Utf-8?B?am9l?= Microsoft ADO .NET 1 5th May 2004 02:16 AM
DataTypes Jim Heavey Microsoft C# .NET 2 14th Jan 2004 04:44 PM
Datatypes Tonya Microsoft Access Queries 3 8th Nov 2003 07:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:22 PM.