Ask Your Question
0

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

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

Comanescu George gravatar image

updated 2015-10-20 13:19:46 +0200

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 4.4.2.2 ( 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 close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,594 times

Last updated: Oct 20 '15