Importing Mixed DataTypes from Excel in ASP.NET

[msturges]

Hi there,

I am encountering a problem importing data into my ASP.NET app from an Excel file where the column data could be either numeric or text(eg '20194567' or 'mikes'). If the initial couple of lines contain text in the said column it appears to convert all subsequent instances where the value is numeric to null?

I have tried formatting the column data in Excel as text in order to read it all in as type string, however the OleDbDataReader still passes a DBNull value back to my ASP.NET application for all instances where the cell's data value is numeric.

Any help would be greatly appreciated.

Thanks
Mike

 

[ZmrAbdulla]

forum855 might be the best place to ask this


________________________________________________________
Zameer Abdulla
Help to find Missing people