399149 web database extraction

IN PROGRESS
Bids
0
Avg Bid (USD)
N/A
Project Budget (USD)
N/A

Project Description:
I need a program to automate the search of the following web database and to extract the records Ideally every record

http://ucbswww.bank-banque-canada.ca/scripts/search_english.cfm

The Last name inputs will be read from a dbf file (or perhaps an SQL or some other database would be best what do you recommend?) In the end I will be using Alpha5 to organize the data so I am familiar with dbf files

The goal is NOT to search for SPECIFIC PERSONS but to capture as many entries from the site as possible. I assume given the sparse search Options of the site the approach is limited to inputing as many last names and their variations as possible I am assuming this the appropriate approach to extract as much of the data as possible? If there is some other way to communicate with the website such that each record can be extractred that is really what I want
As an example the first entires in the last name dbf file would look like this:

Aaron,Aarons,Ahrens, Arrand, Arend, Arends, Aron
Abberly,Abberley
Abbot,Abbott,Abbat,Abot,Abott,Ebbott
Abel,Abele, Abell, Able
Abercrombie,Abercromby
Abernathy,Abernath, Abernethy
Abraham,Abram,Abrams

Each last name would be input into the search box surrounded by quotes so that it would locate only that exact name and only the search returns with the name in the first position (meaning its a last name and not a first name) would be extracted For instance, submitting the last name "Aaron" returns a number of Aarons but none of them appear first so they are all first names and therefore none of these records would be captured at this time (they will be just later on when their last names are searched) However, submitting "Abbott" returns 63 records all with abbott in the last name field so they would all be captured

For each appropriate last name record all the data field: name, payee, savings account etc need to be captured

Each of these bank of canada records must be placed in database file such as dbf file such that they can be imported into my alpha5 database.

Skills required:
Anything Goes, Database Administration, SQL
Hire neilswanson
Project posted by:
neilswanson
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.