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.