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.