We help IT Professionals succeed at work.

VS 2008 C# Reading Excel

rwheeler23
rwheeler23 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
there is an oledb ado.net provider for reading and modifying excel files, here are few articles to help you:-

http://support.microsoft.com/kb/316934
http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx
rwheeler23President

Author

Commented:
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.
rwheeler23President

Author

Commented:
Thanks