3 ms·
"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
by 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.