3 ms·
I think the big point missing in all the comments that suggest linking to the db file and distributing is that it's read-only. Perhaps this is the intent too, b
by gompertz 4y ago
I think the big point missing in all the comments that suggest linking to the db file and distributing is that it's read-only. Perhaps this is the intent too, but often Excel books are shared for other people's input /additions/ corrections to data. When it's linked to a backend database that's no longer trivial. Whereas just using base rows/ columns it's immediately read & write access.
- mcv 4y agoBut this is also a problem with using Excel for this. Let two other people edit it, and now you've got 3 different versions of the data. Which one is correct? Having a single database and giving two other people access to it keeps the data centralised and keeps a single source of truth.