Add_records
How to create an import to add new products from a supplier to the Products table.
Add_and_Replace_records
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_updated_prices_from_Excel
Import data from Excel and replace values on existing records.
One_source_table_-> multiple_destination_tables
Advanced: Add new products and new suppliers to the Products and Suppliers
table in one go. Note: this example also uses elementary VBA code.