4 ms·
I remember back in the 00s Excel could support millions of rows on an office PC used in a bank department to check approvals for loans. I don't want to know wha
by Lanolderen 2y ago
I remember back in the 00s Excel could support millions of rows on an office PC used in a bank department to check approvals for loans. I don't want to know what perversions they're doing now but at some point all that needs to get in normal DBs.
- bayindirh 2y agoExcel has native DB connectivity for quite some time. Maybe they were using that, actually? Libreoffice Calc also supports the same thing over ODBC AFAIK.
- Lanolderen 2y agoDamn, you might be right. I even made a tutorial on Excel ODBC for our sales department recently and completely forgot it's ancient tech. But even then, why in the hell would you query that much shit outside of management diagrams...