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

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.


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:

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.