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

 

[ca8msm]

thread855-1378092 also talked about the same problem you are having.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[msturges]

Hi ca8msm,

Yes, it looks like the same problem. Unfortunately it doesn't seem to highlight the solution.