Ask Your Question
0

Getting a giant spreadsheet into Base!

asked 2016-08-05 14:15:33 +0200

RGavial gravatar image

Alright, I've tried to approach this problem from multiple angles and I just can't seem to make any traction. I am very new at this!

I have a giant 32 sheet .xls (65000 rows per sheet, 2.5 million entries) spreadsheet I’m trying to get into Libre Base. Whenever I use the automated "import from" option when creating the database - it gives me 32 tables.

I'm simply looking for a way to run basic queries (pretty much one field range at a time) on the entire thing. I've tried looking up "merging tables", "relations"? SQL commands to query all tables, copy/paste (my PC is too old, locks up).

PS: The people who made the spreadsheet screwed up by not putting the fields on each sheet after the first one, would adding a proper field row on sheets 2 thru 32 give me just one table when importing?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-08-05 14:30:09 +0200

Ylmith gravatar image

Hello, 2 questions - Did you check that LO Base can handle a sheet that huge? (LO Base specifications) - Did you try to use Calc (copy all the datas in your sheet / paste them directly in your base to create a new table) ? I use small tables though, not sure it can work for you...

edit flag offensive delete link more

Comments

It had never occurred to me tha LO might not be able to handle it. I'll have to check. With your second question - my PC is just too old to copy 65 thousand records. It just locks up.

RGavial gravatar imageRGavial ( 2016-08-05 15:36:44 +0200 )edit
0

answered 2016-08-05 16:55:36 +0200

Ratslinger gravatar image

First, with that amount of data, you should consider using a split database for storage if you haven't done so already. Large amounts of data in an embedded DB can be lost.

If you already have created 32 tables and the data is correct for your needs, then SQL is probably the way to go. You can INSERT records from one table into another until all are in one table. See this link: click here.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-05 14:15:33 +0200

Seen: 70 times

Last updated: Aug 05 '16