<div>
Excellent, thank you. In your opinion, is this the way to go? I am getting more and more these spreadsheets and I also want to do some data validation before I send the data over to SQL.
</div>


Excellent, thank you. In your opinion, is this the way to go? I am getting more and more these spreadsheets and I also want to do some data validation before I send the data over to SQL.

<div>
<div class="content wysiwyg-content">
I am looking for guidance and/or sample code to assist me in creating a VS 2008 C# application that can read values in MS Excel 2007 or 2010. I am having spreadsheets thrown at me that I currently use SSIS to import into SQL tables. It would be far more efficient if I had code that would prompt me for the location of the spreadsheet and then I parse the rows and columns and extract what I need. These spreadsheets will always have the same structure.
</div>
</div>


I am looking for guidance and/or sample code to assist me in creating a VS 2008 C# application that can read values in MS Excel 2007 or 2010. I am having spreadsheets thrown at me that I currently use SSIS to import into SQL tables. It would be far more efficient if I had code that would prompt me for the location of the spreadsheet and then I parse the rows and columns and extract what I need. These spreadsheets will always have the same structure.

VS 2008 C# Reading Excel

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).