Hi Michel,

If you know the exact structure beforehand, you can create the temp table first and then insert into that temp table from the SQL EXEC. The temp table should be in scope then,

Else, you might want to create a regular table and dop it when you're done with it.

Walter,


>OpenRowSet() does not allow to use variables for its parameters. We have to either encapsulate the entire command into a string and SQL exec that or find another way. The first one is complicated as we loose the scope of our temporary table. Anyone has a better approach to resolve that issue?
>
>The problem is that the interpreter for the Stored Procedure is very smart. It detects the name of the Excel file and will not compile if the file does not exist.