This project consists of fixing an issue with an existing VS2010 C#.NET Windows Forms application.
The application includes functionality to import Microsoft Excel files and save data to our MSSQL database through stored procedures. The stored procedures already exist and certain Excel files will import successfully.
The issue may be that the import functionality is looking for colums headers in Excel in a specific position - such as column A, B or C and order of columns in Excel may vary.
I have included a copy of the code from our application that deals with importing from Excel.
We will provide the full source code for the application. The MSSQL database can be connected to via the internet with the existing connection string so it will be easy to test without creating your own environment.
If you have any questions or need additional information, please let us know.
Please see attached file showing our current code and a few samples of XLS files that should be able to be imported.