You would think that they would at least use ACCESS to track Covid cases instead of excel
You would think that at the VERY LEAST they wouldn't be going one COLUMN per case instead of one row per case 🙄
You'd think the folks in management there would be at the very least a little competent
> But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
I... I both understand also absolutely do not understand.
Yes, I know Excel is often treated as a poor-man's database, but... WHAT?!
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.