This is a very simple project.
In the attached .zip file you will find an HTML page. It is for a quiz of sorts, with multiple choice questions.
Your job is to write a program, in Visual Basic 6, that inputs this file and writes the contents to an MS Access database (DAO preferred, RDO ok too. Prefer NO use of Data control), just SQL.
the access database will be set up like so (just one table):
field1: ID (AUTONUMBER)
field2: MODULE (long) (from sample, all are module 4 - you read this from near the top)
field3: EXAM (long) (from sample, all are 18 - you read this from the line that says "This is exam number 18. You've been here **1** times.")
field4: QUESTIONNUMBER (long) (1 through 10)
field5: QUESTIONTEXT (text - 255)
field6: ANSWERA (text - 255)
field7: ANSWERB (text - 255)
field8: ANSWERC (text - 255)
field11: IMAGE (text - 100) should be the SRC of the image that appears with some questions. NOte: in the sample, TWO questions have images, but the SRC is shown as empty (""). you probably want to edit this for testing purposes (ie "[url removed, login to view]" and "[url removed, login to view]") and make sure that this is captured.
I think that's it! Shouldn't be too hard. I want to do this rather quickly, as well.
Ideally, I want you to have one function called
so that I can send many similar files to it and it will parse them all.
Thank You for your bids!
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).
SOURCE CODE MUST BE CLEAN AND REASONABLY COMMeNTED AS I WILL BE BUILDING UPON IT!
Your deliverable is:
1. VB6: one .vbp file
2. VB6: one .frm file that runs the simple parser program
3. VB6: one .bas file with all of the parsing functions in it
4: MS Access: one database file (.mdb) as described.
VB6 / Ms-Access