Hmmm. Excel has supported SQL queries against itself for at least 20 years. This... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		tommy2big on April 6, 2018 \| parent \| context \| favorite \| on: I wandered off and built an IDE Hmmm. Excel has supported SQL queries against itself for at least 20 years. This includes select, insert, update, delete

willhslade on April 6, 2018 [–]

Via MS Query? ADO? OLAP cubes? Care to elaborate for the newbs?

tommy2big on April 6, 2018 | [–]

Yes, MSQuery. Here is the first of many results returned by Google after searching "query Excel spreadsheet" (I didn't bother reading it) http://www.exceluser.com/formulas/msquery-excel-relational-d...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact