Completed

Script to Convert Website Data to Datase

I need a script to click somewhere on a webpage, select all, copy, process the copied data, enter it into an Access database, and then click "next" on the webpage, wait for it to load and start over. It needs to repeat until the "next" button disappears. The first picture shows the website that I want to extract data from.

Is it possible to write this in VB (???), because I used to be VB programmer and can modify the code in the future, if I have to.

The Access table will have fields for Year, CarType, PartType, PartNumber, Description, Pos, Remarks, Unit, Model. (see the 2nd picture). The second picture shows the raw extracted data from a Select All, Copy, and Past into excell. I don't want the information in excell. The picture is to show you what information you will have to process. The last line in the excel workbook shows the year (2010), Cartype (New Beetle), PartType (Engine, Clutch).

Also, if it is possible, I would like to capture the image on the webpage. This might have to be done by an automated printscreen, and crop (using the same box coordinates). The name of the file would be the last line of copy and pasted data. I'm not sure if saving a picture is possible, so it's not that important.

A subscription to the website I'm interested in is $20 per day.

Skills:

See more: i want to be a programmer, excell programmer, data enter data, convert excel to website, 30 second script, write script for website, website pos, pos data, in the clutch, copy to past, convert vb, button to load data from, database copy script, convert script image file pos, excel convert access, image capture access, excel access table, convert line, show image database webpage, pos access 2010

About the Employer:
( 2 reviews ) United States

Project ID: #3186311

Awarded to:

rotfor

See private message.

$170 USD in 4 days
(64 Reviews)
5.8

5 freelancers are bidding on average $281 for this job

matfizvw

See private message.

$416.5 USD in 4 days
(51 Reviews)
5.9
Clucas

See private message.

$212.51 USD in 4 days
(38 Reviews)
4.7
mybreeze

See private message.

$255 USD in 4 days
(9 Reviews)
4.2
SvargaSoft

See private message.

$352.75 USD in 4 days
(12 Reviews)
3.3