Excel Datatype Format Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 out getting a DBNull?

Thanks for help in advance

Tedd
 
You must log in or register to reply here.

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

Extracting Image datatype content with SQL2005? 23
Database datatype to c# datatype 3
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
DBNull class – something very confusing about it 8
Leading Zeros and Number Datatype? 4
Implementation of SqlDataReader and ExecuteReader 1
Problem with reading .xml file using Dataset method 1
how to change the datatype to a column with data 2

Back
Top