OPENROWSET (INSERT) Insert Error: Column Name Or Number Of Supplied Values Does Not Match Table Definition.

Is there a way to avoid entering column names in the excel template for me to create an excel file froma  dynamic excel using openrowset.

I have teh following code but it works fien when column names are given ahead of time.

If I remove the column names from the template and just to Select * from the table and Select * from sheet1 then it tells me that column names donot match.

 Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

here is my code...

SET @sql1='select * from table1'
SET @sql2='select * from table2'  


IF @File_Name = ''   
  Select @fn = 'C:Test1.xls'   
 ELSE   
  Select @fn = 'C:' + @File_Name + '.xls'   
   
-- FileCopy command string formation   
 SELECT @Cmd = 'Copy C:TestTemplate1.xls ' + @fn   
 

-- FielCopy command execution through Shell Command   
 EXEC MASTER..XP_CMDSHELL @cmd, NO_OUTPUT   
   
-- Mentioning the OLEDB Rpovider and excel destination filename   
 set @provider = 'Microsoft.Jet.OLEDB.4.0'   
 set @ExcelString = 'Excel 8.0;HDR=yes;Database=' + @fn   

exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT *   
 FROM [Sheet1$]'')    
 '+ @sql1 + '')   
   
 exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT *   
 FROM [Sheet2$]'')    
 '+ @sql2 + ' ')