How to add multiple rows in libreofficebase

[dvk]

I have a table in LibreOffice base with field names sn, date, transid and amt. I receive data in spreadsheet with same field names. This input data is usually in multiple rows. I need to upload this data in the table in base. I have not been able to figure out how to do it. It is impossible to upload the data by each and every row. Is there any suitable way? Please help.

[gkick]

Hi,

There are several post here on importing from CALC to base.
Here is one

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

Hello, 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 bringi…

Hope this helps

[dvk]

Worked. Thanks a lot.