Hi, I'm trying to build a stored procedure in order to import data from an excel file to a temporary table. I'm using the following code: set @strSql = 'SELECT * INTO #TempTable FROM OPENROWSET( "Microsoft.Jet.OLEDB.4.0", "Excel 12.0;Database=C:\FileName.xls ","SELECT...

My problem (excuse me for being a novice) is that whenever the query becomes complex in the @whereclause (and it does) it cant exceed the character limit of a nvarchar. Now if someone could shed some ligfht on this for me I would be incredibly grateful. I have tried doing the exec(@var1 + @var2) but...