3 ms·

Just to go slightly off-topic, but anybody here felt it would be a dream if Excel allowed pure SQL instead of those absurd formulas like "sum if" etc? (I belie

by Udik 8y ago

Just to go slightly off-topic, but anybody here felt it would be a dream if Excel allowed pure SQL instead of those absurd formulas like "sum if" etc? (I believe that it's (relatively) recently become possible to define tables as SQL data sources, not sure how practical that is or if it's used at all.)

jodrellblank 8y ago
"define tables as SQL data sources" ? Excel can query external data sources with SQL queries, and pull the results back into the spreadsheet. And via ODBC you can use .xls files as data sources, and query them with SQL style syntax from other programs. (I don't know how far beyond the basic "SELECT [Column Name One], [Column Name Two] FROM [Sheet One$]" it can support). Both of those date back - https://www.connectionstrings.com/microsoft-excel-odbc-driver/ https://www.connectionstrings.com/microsoft-excel-odbc-drive... - most look like Excel 2000 or Excel 97.