Creating Temp Tables in an excel query

[goofy78270]

I use the built in query functions to pull info from the database and was wondering if it was possible to create and populate a temp table within the query or if this would have to be done via an ODBC connection or such.

 

[Legacy 98055]

What do you mean by a "temp table". Are changes made to this table ultimately going to be reflected in the database? I have seen this post several times and am not surprised that there have been no replies. Please explain clearly...

 

[goofy78270]

I am looking to create two temp tables - both pull in values from a codeset table - 1 temp table is for all references with Codeset ID 11 and the other is for all references with Codeset ID 24. Within these two temp tables, I am exctracting the Code Num and Description for all references under the appropriate Codeset ID.

Ex

Codesets
1 10 a
1 20 b
1 30 c
11 19 test
11 20 test2
11 21 test3
24 19 apple
24 20 orange
24 21 banana

Temp Table 1 (codeset 11)
19 test
20 test2
21 test3

Temp Table 2 (codeset 24)
19 apple
20 orange
21 banana

based on my knowledge of SQL, I have to create these temp tables to pull back descritpions for each reference to codeset 11 and 24 that are stored in a single table.

ie - product, productID, codeset11, codeset24, price, datein, dateout

 

[Legacy 98055]

Hi Goofy. I still so not understand. The only time, that I know of, to create anything temporal as far as updating a database is concerned, is when I have used disconnected recordsets. It seems to me, that you are simply wishing to return the results of a query...

 

[goofy78270]

Yes, but I cannot, or do not know how, to return multiple lookups from one table without dividing that table into temp tables.

 

[Legacy 98055]

Please email me the table and I'll post an example. tom@jantomsolutions.com