How to convert calc in odb?

I succeed in converting short calc file (about 100 rows for instance) in odb (Libre Office Base) (copy/paste is ok), but it doesn’t work with a calc file of 164 380 rows, it finishes in a “null pointer” error if I paste it into Libre Office Base. I imagine this is a bug due to a limit in Libre Office Base, since I can see my 164380 rows in calc without any problem…

Since I don’t know what is the limit of copy/paste number of rows, I don’t know how to do it exactly.

Isn’t there a program / module / add-on able to copy/paste large calc file > 150 000 rows to create an odb database ? Or can we know the limit of the number of rows we can copy/paste from calc to odb ? I suggest a possible evolution of Base, that could be create a table directly from a calc file, since I’ve seen many of questions on the net about that question, and it’s easy to convert any text file in calc, so it could be usefull to import any kind of file data into a database with such a function.

Thank you for your answer.

This might give you the answer:
https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base

There is very good information available from the Help Wiki:
https://help.libreoffice.org/Special%3ASearch

Absolutely not, I said there is a bug when using a 164 000 rows calc file. Doesn’t work, it was the sens of my question, how to do this with big files ?