Where to find the Base module of LibreOffice that has no row limit?

Question

I have a file that has ten million rows. I want to open it using OpenOffice Calc but OpenOffice Calc 3.3.3 has a limit of around one million rows.

If you follow this link, the answer mentioned that the Base module of LibreOffice has NO ROW LIMIT.

Answer 1

LibreOffice Base can use Text files as the data source. Documentation is here: https://help.libreoffice.org/Common/Text_File_Connection.

To test this, the following python script produces a text file with ten million rows.

with open("datasource.txt", 'w') as f:
    f.write("id,name\n")
    TEN_MILLION = 10000000
    for id_number in range(TEN_MILLION):
        f.write("%d,abc\n" % id_number)

Open Base by going to File -> New -> Database in the LibreOffice menu. Then connect to an existing database.

Now, the "datasource" table can be viewed by opening it.