29 Mar
2022
29 Mar
'22
4:17 p.m.
On Tue, Mar 29, 2022 at 03:32:57PM +0100, Bev Nicolson wrote:
On 29/03/2022 14:42, Chris Green wrote:
On Tue, Mar 29, 2022 at 11:39:34AM +0100, Phil Thane wrote:
Database nerds look away now.
I hate to say it but the obvious answer is that the data shouldn't be in a spreadsheet! :-)
If Phil ever needs to share it though, Calc will be easier to work with because Base remains incompatible with MS Access. Otherwise, yes.
Don't use either Access or Base, the GUI just adds complication and complexity.
Export to CSV, import into a sqlite3 database and write a one-liner in sqlite3 CLI to get the result you want. It might be worth using something like sqliteman to do the CSV import but otherwise just use command line.
--
Chris Green