Hello, I need to import a csv file into a database. The file has 4990101 rows, but if I open it, Calc gives me this error:
the maximum number of rows Has Been exceeded.
How can I do?
The maximum rows in calc are 2^20 1048576. So I think in calc nothing usable.
The better/only option could be open CSV file in Base as if it was a database, doing queries to reduce/summarize the data and link it in calc.
Great! Thank you.
But i have another problem: If I open the table i see the cell’s value like this:
“V A L U E” with white space between letters, i think it’s an error on encoding?
If i open the file with Notepad++ it show me the encoding is “UNIX UCS-2 Little Endian”, but if i try to set “Database\property\character set” in UTF-8 or UTF-7 it doesn’t work
I can’t see that character set in the list for select in Base, If you are not going to update the data regularly, try changing the character set with notepad.
This is not good news for data mining, I hope the product will be improved to include more rows. I am not sure about LibreOffice Base either.