Ask Your Question

How may I append data from Calc to an existing table in Base? [closed]

asked 2014-10-25 03:48:24 +0200

mrmister gravatar image

updated 2014-10-25 03:51:54 +0200

Hi, I have a problem with this. Sadly I did not find any example and I even tried to read the Base manual, but I did not find how to append data efficiently. The situation is this: I have a calc file, with 37 rows (that would be 37 records in a Base table) Of course, in the calc file I don't have a primary key, I only have columns with the data. Several columns, 37 rows. All that with data. What I did is to copy and paste all those data in Base and I followed the assistant, copied all the data, added the primary key, also copied all the column's data in the new Base table, etc. So what I have in base is a perfect copy of what I have in Calc, showing in Base all the columns with their names, all the rows of data perfectly copied and also (and this is only in Base) I have a new column, with the primary key created and all the numbers: 1, 2, 3, 4, 5... for every record (row). Okay. Now how may I append new data from Calc to that table in Base? In calc I don't have a primary key, so when I try to copy and append data, I always get errors. How may I append new data that eventually I could have in Calc to my Base table? Cheers

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 2016-03-05 11:57:21.444000

1 Answer

Sort by » oldest newest most voted

answered 2014-10-26 09:29:51 +0200

Alex Thurgood gravatar image

Add an empty column to your Calc sheet, in front of your other columns, i.e. as the first column.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-25 03:48:24 +0200

Seen: 898 times

Last updated: Oct 26 '14