I love this part: "To handle the problem, PHE is now breaking down the test result data into smaller batches to create a larger number of Excel templates. That should ensure none hit their cap."
There is an ODBC driver for Excel. Not to put data into Excel -- To get it back out, treating it as if it were a database.
what do you mean, Excel isn't a Database?
It is according to UK's National Health Service: https://www.bbc.com/news/technology-54423988
I love this part: "To handle the problem, PHE is now breaking down the test result data into smaller batches to create a larger number of Excel templates. That should ensure none hit their cap."
There is an ODBC driver for Excel. Not to put data into Excel -- To get it back out, treating it as if it were a database.
This is exactly as bad an idea as it sounds.