Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Query and Local Tables in Excel
I have a group of Access queries that I run in sequence across an ODBC
connection against an Oracle database. The first two are update queries that create local Access tables that are then queried by the remaining queries in the group. In other words, the first two queries query Oracle and create two local tables. Subsequent queries query the two local tables to further refine the result set. I am trying to migrate this whole operation to Excel since this is ultimately where the result set is used. I can query Oracle through ODBC from Excel. No problem. But now I'm stuck. I somehow need to create a "local table" of the result set in Excel that I can later query. Or is there a way for me to query the resulting recordset itself? I've read through many of the postings on the site and consulted the books I have and the help files, but I haven't been able to pull all of the pieces together. Can anyone point me in the right direction? Thanks in advance!!! -- Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Local OLAP cubes in Excel/MS Query | New Users to Excel | |||
Excel 2000 on WTS 2003 and local Excel links don't update | Excel Discussion (Misc queries) | |||
Stoping users from saving tables to their local machines... | Excel Discussion (Misc queries) | |||
Two Excel tables in MS Query | Excel Discussion (Misc queries) | |||
Reference styles and local/non-local formulae - international problems. | Excel Programming |