You are able to append data to a table by dragging and dropping from a Calc
document. This opens the Copy Table dialog where you can select Append data. If
you give the name of the table you want to append to, the next screen shows the
dragged fields beside the table's fields.
You should be able to reorder the right side so that the fields match up
correctly. This apparently has no effect. The data is imported into the fields
sequentially, even if datatypes do not match up correctly (it will try to put
VARCHAR into an INT).
The attached zip file contains 2 OOo files to test for replication.
Open the database and click the tables icon.
Open the Calc document and range-select all the cells with data. Click and drag
this over to the database application and drop it in the area that lists the table.
Select "Append data" and enter "Contacts" as the table name. Click next.
Click the up buttons so that Name and Phone are the first two fields.
Press Create and see the error.
It tries to insert into "id","Name" instead of "Name","Phone" as expected.