470,810 Members | 1,016 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 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

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


Nov 15 '05 #1
0 1384

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
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.