fossilesque@mander.xyzM to Science Memes@mander.xyzEnglish · 1 年前despite all my rage IT keeps me trapped like a rat in a cage.mander.xyzimagemessage-square211fedilinkarrow-up11.27Karrow-down140
arrow-up11.23Karrow-down1imagedespite all my rage IT keeps me trapped like a rat in a cage.mander.xyzfossilesque@mander.xyzM to Science Memes@mander.xyzEnglish · 1 年前message-square211fedilink
minus-square1371113@lemmy.worldlinkfedilinkEnglisharrow-up3·1 年前Until it has an odbc connection to a sql server or access db it’s still low level wizardry.
minus-squareknorke3@lemm.eelinkfedilinkEnglisharrow-up3·1 年前you can access sql from excel? i am now officially horrified.
minus-squarerunner_g@lemmy.blahaj.zonelinkfedilinkEnglisharrow-up3·1 年前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.
minus-square1371113@lemmy.worldlinkfedilinkEnglisharrow-up1·1 年前You can issue queries, import and transform the data on demand.
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.
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…
You can issue queries, import and transform the data on demand.