This video demonstrates how to open the results of a SQL query into Microsoft Excel and query an Excel spreadsheet with SQL. It explains how to create an ODBC data source referencing an Excel file. Once done, you can treat an Excel sheet like a table in a relational database and run SQL queries to pull as well as modify data.
ViDoe Login
Upload videos, create your own free channel with ViDoe.Top after login