| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't change query definition in MSQuery
Hi,
We've got "reports" in Excel 2002 that were created using MSQuery to run queries against an Oracle database. Now we need to alter the query. We modify the query, return the data to Excel, but the altered SQL is not saved. Is this a bug? Shouldn't we be able to edit and save the query? I've used VBA before to change the connection property of pivot tables but I didn't think VBA was necessary to modify the SQL. Thanks, Scott P. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Query Definition | Excel Discussion (Misc queries) | |||
| creating a query using MSQuery | Excel Discussion (Misc queries) | |||
| lost query definition | Excel Discussion (Misc queries) | |||
| Multiple ODBC Database lik in one MSQUERY query | Excel Discussion (Misc queries) | |||
| Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
Threaded Mode
