ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OleDB returning DBNull for numeric cells (https://www.excelbanter.com/excel-programming/284464-oledb-returning-dbnull-numeric-cells.html)

Paul

OleDB returning DBNull for numeric cells
 
Hi,

I'm using OleDBConnection in a .NET app to read data from
Excel. I'm able to read everything except when a cell has
numeric value and the column has alphanumeric data. I get
DBNull when it encounters a numeric value. I'm sure many
people have seen this. Does anyone know how to address
this issue?

Thanks,
Paul


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com