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
http://help.libreoffice.org/Common/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?
Sincerely,
Ray
[business case]
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.