Over the last few years, I have an OpenOffice Calc spreadsheet that has
grown to:
500 rows X 100 columns
Simple searches are too limited:
Find rows where field D = someText
Need to do more complex "queries" like:
Show all rows
Where field A is blank
and field D = someText
and field H > 95
or field K > 95
or field P > 95
A. How can such searches be done within Calc?
B. How can I convert this spreadsheet into a database table, accesssible to
SQL-like queries, like the above example?
What else ought I consider?
Please, advise. Thank you.
~ Mike
