The job is to use the PDF document [url removed, login to view] and convert the text data into an MS ACCESS database and a table called LoadData. Then to use the excel spreadsheet and copy paste the data into the same database but table PriceData. I have included a sample database, an image showing field names, and the excel spreadsheet. Special characters must be converted into text forms, eg " must be entered as Inch. No carriage returns can appear in the database at all. 3/4 is acceptable. SO 3/4" should be written as 3/4 Inch.
Each line for the comment data is entered as a separate comment, eg comment1 for line1, comment2 for line2. Only ex VAT prices should be entered.