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