Ask Your Question
0

How to convert calc in odb ? [closed]

asked 2013-08-24 08:29:40 +0200

this post is marked as community wiki

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

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 03:49:55.055799

1 Answer

Sort by » oldest newest most voted
0

answered 2013-08-24 14:27:51 +0200

ROSt52 gravatar image

This might give you the answer: https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base

There is very good information available from the Help Wiki: https://help.libreoffice.org/Special%3ASearch

edit flag offensive delete link more

Comments

Absolutely not, I said there is a bug when using a 164 000 rows calc file. Doesn't work, it was the sens of my question, how to do this with big files ?

Convert calc in odb gravatar imageConvert calc in odb ( 2013-08-24 19:59:24 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-08-24 08:29:40 +0200

Seen: 3,182 times

Last updated: Aug 24 '13