Apologies if this is in the wrong forum area - I could not quite figure out whether it is Excel related (due to being embedded query) or whether it would be better suited in an external program forum area.

Embedding a query that includes a CREATE TABLE function is something that we have not been able to do, as MS Query does not seem to allow this, so at present we have to go into Teradata, run the query and copy the answerset into Excel.

Ideally, we want to be able to click a macro button and refresh one of two queries within the file itself, and it does all the work.

The beginning of the query is currently this:

CREATE TABLE *database name*.*table name*

and then the query pulls back and dumps all the data into the temporary table, to give us our answerset.

Is there any way to make MS Query do the same thing, thus negating the need to reference the data externally?

Many thanks for any help!

Kind Regards

Jenn