I need a small VB .NET application with the following functionality:
(1) Using a Windows Form, allow a user to search for and then select a Microsoft Excel file that resides locally or on a remote (networked) server. Provide a label or disabled text box to display selected file.
(2) Once the Excel file is selected, provide a drop down list of available Sheets within the spreadsheet file for user selection.
(3) Provide two buttons: Cancel (quit app); and Import to start the process of importing the Excel Sheet data into an existing SQL Server table.
Sample Excel file and SQL Server table structure will be provided.
The import routine will first call a SQL Server stored procedure that will create two new SQL Server tables from existing template tables to be used during the import process. This stored procedure will be provided.
The stored procedure will return the name of the two new tables to be used. The first returned value will be the name of the first table, which will contain all successful imported Excel data. The second returned value will be the name of the second table, which will have the same structure as the first import table but with an added column for error description and will hold any Excel rows that did not import and the reason why the rows did not import. The result of the import process will be a table containing all valid import data and another table containing all invalid import data.
Application is straight forward, but must contain error checking and data tranformation to ensure proper importing of data.
I could do this in VB 6 in an hour or so and would expect a VB .NET expert to be able to do about the same. I will expect a total dollar quote on the completed project. Hourly rate quotes will not be accepted.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2000, Windows XP, SQL Server 2000, Visual Basic .NET 2003, .NET Framwork 1.1