25 ms·
Hmmm. Excel has supported SQL queries against itself for at least 20 years. This includes select, insert, update, delete
by tommy2big 9y ago
Hmmm. Excel has supported SQL queries against itself for at least 20 years. This includes select, insert, update, delete
- willhslade 9y agoVia MS Query? ADO? OLAP cubes? Care to elaborate for the newbs?
- tommy2big 9y agoYes, 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-data.htm http://www.exceluser.com/formulas/msquery-excel-relational-d...