Error : the maximum number of rows has been exceeded [closed]

calc
base

asked 2014-02-18 16:22:40 +0100

teo
3 ●1 ●1 ●2

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:14:23.585001

add a comment

0

answered 2014-02-18 21:44:22 +0100

m.a.riosv

25709 ●7 ●53 ●139

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.

edit flag offensive delete link

Comments

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

teo ( 2014-02-19 08:40:17 +0100 )edit

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.

m.a.riosv ( 2014-02-19 23:05:47 +0100 )edit

add a comment

0

answered 2015-10-17 12:15:39 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit flag offensive delete link

add a comment

Error : the maximum number of rows has been exceeded [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:14:23.585001

2 Answers

Comments

Question Tools

Stats

Related questions

Error : the maximum number of rows has been exceeded [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-19 11:14:23.585001

2 Answers

Comments

Question Tools

Stats

Related questions

Error : the maximum number of rows has been exceeded [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:14:23.585001