You are trying the first of Peter's options?
Quote
Simplest for you at this stage is to import into your table from the table created by importing the .ods file.
If I understand correctly, you now have two tables. Your original table, and a new table created by importing the .ods file?
To copy (import) from your new table to your original table, you will need something like
INSERT into original_table(col1, col2, ...) SELECT (colx, coly, ...) from new_table;
Use your original table name for 'original_table' and the table name created by the import for 'new_table'.
You can insert any of your new column data into the desired column of your original table.
When you have a satisfactory result you can DROP the imported table.
Good luck,
Barry.