Skip navigation.

Tips for reading Excel data using ADO.NET

Tips for reading Excel data using ADO.NET

Yes, we've all seen this code a thousand times. However, this blog post does more than just rehash the same old Microsoft KB article. In it Joe Morrison shows how to read line-by-line, how to hack past ADO.NET's guessing of the data type with the first 8 rows, and more.