Open an Excel Workbook

Question

Hello,

I am finding it extremely difficult to open an Excel workbook that I have saved in my bin.  I am using Office 2010 and Visual Studio 2010.  I have added the Microsoft.Office.Interop.Excel reference and a
Using Microsoft.Office.Interop.Excel statement.

My goal is to open a workbook, send all of the data to a datatable, do some searching for specific values then insert the chosen values to sql.  The only part I can not due is is open the workbook.  I can do it with csv file, but because of the nature of the data commas appear where I do not want them and I cannot control that.

Thank you,

RJ