How to create an import to add new products from a supplier to the Products table.
The system uses the key to see if a record already exists. If yes, it will choose to Replace that record, if no, it will Add a new record.
Import data from Excel and replace values on existing records.
Advanced: Add new products and new suppliers to the Products and Suppliers table in one go. Note: this example also uses elementary VBA code.