Dear LO Base team:
The procedure of importing data from a spreadsheet into a LO Base table works as SQL Insert statement, as shown below in the LO Help forum. i.e., for adding data rows of NEW, DISTINCT primary keys into an existing / defined SQL table.
Importing and exporting data in Base
Is there a procedure working as SQL Update statement? i.e., for updating existing rows (EXISTING primary keys) in a SQL table?
Business operation always copes with dynamic data.
Client POs undergo frequent revisions of delivery date, purchase quantity, colors, etc. Client issues revision of multiple POs (batch mode) in spreadsheet. A partially automated procedure of data import for SQL Update, similar to that for SQL Insert above, is crucial for the business case of LO Base.