5 ms·
Looks great but I would guess all this functionality is already built into excel somewhere. You just have to be ninja enough to find it.
by Too 10y ago
Looks great but I would guess all this functionality is already built into excel somewhere. You just have to be ninja enough to find it.
- anakic 10y agoWell, some things you certainly could, but this really opens up many more possibilities than is obvious at first glance. Another big thing is convenience, which is along the lines of what you said. Single click to open query editor, full autocomplete, star expansion, etc., easy 2-way communication between a db and Excel (instead of the clunky import/export procedures). There are a ton of areas where this offers benefits, in larger or smaller ways. It can solve problems people don't even recognize.
- devoply 10y agoI guess that's one problem you have to worry about now. Microsoft is bound to incorporate something like this into Excel sooner or later. :(
- ZenoArrow 10y agoYou can write SQL queries in Excel (in numerous different parts of the application), but no built in SQL autocomplete in Excel AFAIK.
- DCoder 10y agoExcel has Get & Transform, formerly known as Power Query, which can do similar things... if a custom query language [1] instead of SQL doesn't scare you away. I have used it a few times, it can definitely be useful. [1]: https://msdn.microsoft.com/en-us/library/mt270258.aspx https://msdn.microsoft.com/en-us/library/mt270258.aspx