We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How do I append a calc spreadsheet to a base table?

asked 2020-12-05 21:05:55 +0200

Casey37 gravatar image

I have a base database table established. How do I append from a calc sheet to this table? Both structures are exactly the same. Sometimes I get an error. Sometimes it looks like it worked but only the header record appended. I copy the spreadsheet in calc and paste it to the table in base. It should be a simple operation. I must be missing something.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-12-05 21:58:18 +0200

Ratslinger gravatar image

updated 2020-12-05 22:22:48 +0200


To me this is a simple operation. However, based on multiple questions asked, it seems to many others this is not so simple.

In your question you do not present much in the way of information - LO version, database used and the specific error you seem to get.

Here is a starting point with Calc as top view and the Base table is below it:

image description

Then select in Calc what is to be copied:

image description

Next is to right mouse click on Base table & select Paste bringing up this dialog:

image description

As long as all columns are identical in name & sequence, click create & result is:

image description

Now depending upon your data and many variations, much can go wrong. If in this sample I changed one of the input records to have an ID of 2 and proceeded, this is the result:

image description

Many other things may be a problem such as data types not matching.

So it is important that if you continue to have problems, include specific information.

Please do not use Answer for any responses. Original question can be edited or a comment added to include further information.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-05 21:05:55 +0200

Seen: 76 times

Last updated: Dec 05 '20