read text file and change a flag in database

IN PROGRESS
Bids
15
Avg Bid (USD)
$34
Project Budget (USD)
$30 - $60

Project Description:
I want the coder to only use visual basic 6 (ONLY) as i will include minor modifications to it, and i would like it to have a simple program which will allow me to manuelly run everyday.
The program will check for a FAILED status in the line then process that line.
When the failed is found it will then process on that line and extract the fax number, failed status/HEADER->"result".
these two things are the only importance for this project.
Any lines containing success are skipped lines.

Once you have the results you need to loop through each one and check the db table and field for the fax number if it is found then change the flag column to value of -> "FAILED".
needing to know the result is important so it would be nice to have it also put in another field the same table called column name "RESULTINFO" --> "the_value_of_result_here".

The connection must be to SQL server, and i have included what the interface will look like and have included the text file.
The connection to the db must be through odbc and i must be able to change the information via the interface i have included.


the log is currently at 24,000 lines, i would like after it reads the lines and is done changing the flag in the db to rename the file to the current date with underscores example
4_10_2004.txt

I've included the LOG file too with 4-5 lines of real data that it will have.
The file is connected via a network path !

PLEASE VIEW ATTACHED FILES TO SEE THE PROJECT BETTER !
Ive made the basic forms via visual basic and included the text file

## 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 xp only

Skills required:
Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL, Visual Basic
Additional Files: zRAC_DOC_NameCryptedToProtectYourPrivacy_X20049191811967688247058775356278844622554538171403161222335812501803.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire Premshanks
$ 33.15
in 2 days
Hire sixthsensevw
$ 21.25
in 2 days
Hire sawamu
$ 21.25
in 2 days
Hire maramayvw
$ 38.25
in 2 days
Hire ebshightechvw
$ 29.75
in 2 days
Hire juran
$ 42.5
in 2 days
Hire tlacorte
$ 42.5
in 2 days
Hire DigitalDreamz
$ 17
in 2 days
Hire onesource
$ 42.5
in 2 days
Hire khurrambinumer
$ 25.5
in 2 days