I have 3 (three) excel files with a fixed format, and every row have 8 columns. 4 columns are data to locate in a database in SQL Server (key fields). The other 4 columns contains data to insert or update in the same database. Each row can generate more than 1 (one) record on a table and can affect 3 or 4 tables in the database. Additionally, you must detect if the key fields data exists on the database and if so, update the database. if not, write a log file. The data access is made with ADO and the code must be Visual Basic 6.0 in only one form. The excel files can be located by browsing, and if the format doesn´t comply with especification, must be messaged to the user.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Windows 98/XP, Visual Basic 6.0, SQL Server 7.0 or higher