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?