It can also link nicely over odbc to full databases which are represented a nice tables…with links between sheets…waiiit a second.
Abusing Excel as a crappy database is a very real and very widespread problem.
ruse8145@lemmy.sdf.org 4 months ago
Abusing Excel as a crappy database is a very real and very widespread problem.
It can also link nicely over odbc to full databases which are represented a nice tables…with links between sheets…waiiit a second.
gibmiser@lemmy.world 4 months ago
You use what ya got, and you don’t buy database software or hire a database guy until you know you need one
Takumidesh@lemmy.world 4 months ago
But access comes with office, so if you have excel you have at least a software that is intended to be used as a DB (efficacy aside)
micka190@lemmy.world 4 months ago
Let’s be real, using Excel as a makeshift database is probably still better than actually using Access lol
Fisch@discuss.tchncs.de 4 months ago
When I started studying IT at a Berufskolleg (German word, literal transaltion would be something like job college or job school), we started learning about databases by using Access. We were all so happy when we were done with that and just used SQL. I fucking hate Access.
sevan@lemmy.ca 4 months ago
The only use case I can see for Access is when you absolutely must have a database and your company will not provide you a real database solution. I have experience with both, but haven’t touched Access in years (and hope to never do so again). To be fair, I also regularly use Excel for things that I should probably be using Word for because it is easier to get formatting right in Excel.
RecluseRamble@lemmy.dbzer0.com 4 months ago
Probably true for most companies but I worked at one that had plenty of DB servers and developers, even developed their own database tech. Still, Excelitis as we called it was rampant.
Appoxo@lemmy.dbzer0.com 4 months ago
Nothings more permanent than a temporary solution.