I look after the company's access database which records the company's products from different suppliers. The table's primary key is the product code and the table also contains a description of the item, the supplier, if discontinued, buying in price and RRP. The product prices are updated from a spreadsheet sent by the supplier. Is there a way to update the prices in the table directly from the spreadsheet and record them as discontinued if they are missing?
dave.wright
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.