Can you QUICKLY
1. write a script to ROBOTICALLY copy the thousands of shopping items on this website
[login to view URL]
into a new access DB on my server storing:
* name
* unit (eg each or 600grams or 2pk or etc)
* price
* special price (if exists)
* image file number
* category
Create and fill tables:
a. ProductTBL
ProductID (key)
ProductName (string)
Unit (string)
Price (currency)
Special (currency)
Image (integer)
CategoryID (integer)
b. CategoryTBL
CategoryID (key)
CategoryName (string)
ParentID (integer)
Copy all THUMBNAIL images as images/<filenumber> on my server. THERE IS NO NEED TO 'GO INSIDE' EACH ITEM.
2. Build a webpage on my server which displays the hierarchy of items (starting with all categories and sub-categories closed). Categories and sub-categories can be opened displaying all details in a single line per item including image.