fossilesque@mander.xyzM to Science Memes@mander.xyzEnglish · 2 years agodespite all my rage IT keeps me trapped like a rat in a cage.mander.xyzimagemessage-square202linkfedilinkarrow-up11.21Karrow-down139
arrow-up11.17Karrow-down1imagedespite all my rage IT keeps me trapped like a rat in a cage.mander.xyzfossilesque@mander.xyzM to Science Memes@mander.xyzEnglish · 2 years agomessage-square202linkfedilink
minus-square1371113@lemmy.worldlinkfedilinkEnglisharrow-up3·2 years agoUntil it has an odbc connection to a sql server or access db it’s still low level wizardry.
minus-squareknorke3@lemm.eelinkfedilinkEnglisharrow-up3·2 years agoyou can access sql from excel? i am now officially horrified.
minus-square1371113@lemmy.worldlinkfedilinkEnglisharrow-up1·2 years agoYou can issue queries, import and transform the data on demand.
minus-squarerunner_g@lemmy.blahaj.zonelinkfedilinkEnglisharrow-up0·2 years agoNext time you open excel go to the data tab and look at all the things it can do. It really shouldn’t do those things, but it can.
minus-square1371113@lemmy.worldlinkfedilinkEnglisharrow-up1·2 years agoSince the 90s for a lot of it…
Until it has an odbc connection to a sql server or access db it’s still low level wizardry.
you can access sql from excel? i am now officially horrified.
You can issue queries, import and transform the data on demand.
Next time you open excel go to the data tab and look at all the things it can do.
It really shouldn’t do those things, but it can.
Since the 90s for a lot of it…