Creating Temporary tables through Excel

Third Party Software

Creating Temporary tables through Excel

Hi,

Is there a way to create temporary tables in Teradata using an Excel connection?  I would like to run a select query afterwards, which I can run.  However, creating the temporary tables is difficulat.

Thoughts?

2 REPLIES

Re: Creating Temporary tables through Excel

i believe you have data in excel and wanted to load in teradata  table for temperory purpose. 

You may use csv format and upload it to teradata table through SQL assistant export option or Bteq with vartext mode. And can query the table after load.

--

Re: Creating Temporary tables through Excel

Thanks for the reply, I basically have a select query linked to Teradata in Excel.  However, that select query contains temporary tables in joins, and therefore I want to create those temporary tables prior to the select query being ran.  With that said, is it possible to setup a function to execute the create volatile table query from Excel itself.