>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