Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Libre Base using text files IS limited to single table queries. From your question it appears the text files contain more than a million records ("it won't even open in Calc"). Even if you load this into a default Base file you will soon have problems as the embedded DB is prone to problems with large amounts of data. Moving up to a split DB is a possibility and reduces the chances of error since the data is removed from the .odb - posted here. The split DB also upgrades the HSQL to 2.x (from the embedded 1.8). With this you may be able to load the data (csv?) using 'sqltool' - see this post.

Other databases have more friendly commands such as MySQL -

LOAD DATA LOCAL INFILE 'YOUR_FILE' INTO TABLE YOUR_TABLE FIELDS TERMINATED BY ','

converts a comma separated text file into a table.

Hello,

Libre Base using text files IS limited to single table queries. From your question it appears the text files contain more than a million records ("it won't even open in Calc"). Even if you load this into a default Base file you will soon have problems as the embedded DB is prone to problems with large amounts of data. Moving up to a split DB is a possibility and reduces the chances of error since the data is removed from the .odb - posted here. The split DB also upgrades the HSQL to 2.x (from the embedded 1.8). With this you may be able to load the data (csv?) using 'sqltool' - see this post.

Other databases have more friendly commands such as MySQL -

LOAD DATA LOCAL INFILE 'YOUR_FILE' INTO TABLE YOUR_TABLE FIELDS TERMINATED BY ','

converts loads a comma separated text file into a table.