declare @f varchar(500)
set @f='d:\book1.xls'exec('SELECT * FROM OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source='+@f+''';User ID=Admin;Password=;Extended properties=Excel 5.0'')... sheet1$')
set @f='d:\book1.xls'exec('SELECT * FROM OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source='+@f+''';User ID=Admin;Password=;Extended properties=Excel 5.0'')... sheet1$')
set @f='d:\ book1.xls'
execute ('SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source=' + @f +' ;User ID=Admin;Password=;Extended properties=Excel 5.0' )... sheet1$')