I need you to make a products database in access which can work out selling prices, import and format an xml file from my supplier's site.
The xml file contains product details and a field with product description which has custom tags. I would need these formatted in html so that I can export from access either a csv file or directly into mysql.
I have a product list right now with my own product codes which I buy into stock right now. I do not currently buy all the items from my suppliers feed but I do want them in the database. I need to find a way to differentiate between them so I know which item is a stock item and which is from the suppliers feed. I would also need an easy way to get rid of duplicate items which may be worded differently, I know this will have to be done manually but I don't mind as long as there is an easy way to do it.
I have attached a sample copy of the xml file.