Link Excel spreadsheet to SQL Server 2005

Create "New Linked Server" in the linked servers tree
* Name it
* Provider: Microsoft Jet 4.0 OLE DB Provider
* Product Name: Excel
* Data Source: c:\xxxx\xxxx\xx.xls
* Provider String: Excel 8.0

Then choose OK - make sure you have the file in the proper directory.