One of the questions that was asked at the SQL Server presentation at QUT last week was how to load data from an Excel Spreadsheet into a SQL Server table. To answer this question I have created a Camtasia screencast of how to use SQL Server Integration Services (SSIS) to load an Excel Spreadsheet. A wmv of this screencast can be downloaded from here.
