Ask Your Question

How to import data from Calc into an existing Base table? [closed]

asked 2015-10-18 12:46:40 +0100

Comanescu George gravatar image

updated 2020-08-26 21:57:46 +0100

Alex Kemp gravatar image

Hellow everyone. I've tried to find a solution on how to copy multiple table entries from a Calc spreadsheet into an existing Base table. For example i have a table with movie titles, and i want to add those titles into the existing table i got in the database. The only viable solution i have found, is to insert the data by using the "paste special" button, but that creates a new table...and i could just merge the 2 tables but i can't seem to find how to do that either. So if anyone has a solution .. please help :D

App& OS data : LibreOffice ( i normally use the 5.x.x variant, but the paste special option is non existent in 5.x.x installed on Sabayon Linux,so now i'm on Ubuntu) Ubuntu 15.04.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-26 21:58:26.463955

1 Answer

Sort by » oldest newest most voted

answered 2015-10-20 04:31:58 +0100

doug gravatar image

click on the base table, then use the special paste. That makes things smoother, but the popup window is the same. You should receive a window that asks whether you want to create a new table, append data, etc.

image description

maybe the Create button is a little misleading, but Append means to add the data to an existing table.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-10-18 12:46:40 +0100

Seen: 2,544 times

Last updated: Oct 20 '15