>I want to send an excel file to a temp sql table and manipulate
>the temp file with a table in a sql database.
>
>I will need to blow away the temp sql table when I am done.
>Please help.
>Thanks,
>Doug

Doug,
SQL server can open an xls file using Jet OLEDB provider (OpenDataSource). ie:

SELECT * into #temp
  FROM OpenDataSource( 
  'Microsoft.Jet.OLEDB.4.0',
  'Data Source="c:\myPath\myExcelFiel.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheetname$

Cetin