SQL Server 2008 - StoredProcedure

[Stevie]

SQL-Code:

declare @sql varchar(max);
declare @filename varchar(100);

set @filename = 'c:\test.xls'
set @sql = 'SELECT * INTO Import FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
  ''Excel 8.0;Database=' + @filename + ''', ''SELECT * FROM [Tabelle1$]'')';

exec (@sql);