Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running multiple queries in Microsoft Query in Excel
I have created this report that uses Pivot tables and Microsoft Query
to populate the Excel file and extract data from a Oracle database. To increase the security in these reports, I have created a stored procedure which when run populates a temp table. on which I run the select statement. I have been able to run both the commands individually but not one after the other in Microsoft Query. Can someone please advise me on how I might be able to run these one after the other. Thank you. A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open all Excel spreadsheets/fles before running queries | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
Running speed of Micrsoft Query with Multiple parameters | Excel Discussion (Misc queries) | |||
Running Queries to Oracle from Excel 2000 | Excel Programming | |||
Running Access queries from Excel | Excel Programming |