excel 2007

Hi I am writing a XML Based Visual Studio application, whereby I need to import a simple matrix of 6 columns by 400 rows of data. The scenario is that the user puts in question number and the application looks up the question and display the 5 columns of the answer in the below format from the...

This has been driving me nuts all day and hopefully someone here knows a solution. Using VB2010, .NET v4.0 framework, have a reference to the "Microsoft Excel12.0 Object Library" set (working with Excel 2007) and have the Microsoft.Office.Interop imported and all of my other code to format an...