You can do this, but there is a minor problem. The scope of a temperary table is limited to the procedure that it is declared in.

If you declare the...

I do this all the time.

Just open excel and click on the

Data, Get External Data, New Database Query

Then pick the ODBC Conection to the database you want to access....