467,903 Members | 1,809 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,903 developers. It's quick & easy.

Excel Data Type Format Issue

Language: C
Excel Reading Method: ExecuteReade

I am currently running into a challenge reading excel data when datatype formats are different in the SAME column. It seems like datatype (in the OleDbDataReader schema) is set by the first data row and that causes a problem if any of the subsequent rows in that column holds a diffrent datatype
Exampl
Zi
------
2926
9474

First row is stored as text in excel and second is stored as numeric (result of client cut'n paste that carries over formatting on a cell that is previously defined as text). Looping through the content is giving 29267 for first row and DBNull for second row

Is there a way to read the second value with getting a DBNull?

Thanks for help in advance

Tedd

Nov 15 '05 #1
  • viewed: 1325
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
3 posts views Thread by ggupta78 | last post: by
4 posts views Thread by =?Utf-8?B?QnJpYW5ESA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.