MySQL Forums
Forum List  »  Newbie

Re: Import Excel ods file problem
Posted by: Barry Galbraith
Date: March 27, 2022 05:38PM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Import Excel ods file problem
March 27, 2022 05:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.