Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query instead of "Edit OLE DB Query"
Hello all,
I am having a problem with editing some existing queries within Excel 2003 workbooks. When clicking on the "Edit Query" button from the External Data toolbar, I now get the "Edit OLE DB Query" dialog box, instead of MS Query, which was the interface that I previously would get. Is there a way to switch this back? I have been using Office 2003 on Windows XP Pro SP2. I recently had Microsoft Update upgrade my version of Office 2003 from SP2 to SP3. The problems appear to have started after that. I can still create new queries in Excel using MS Query, which is good. I would really like to be able to edit all of the previously existing ones in MS Query, also. Are there any registry, ODBC, OLE, etc. settings that I can modify to change this? Any help is greatly appreciated! Thanks in advance. Casey. |
#2
|
|||
|
|||
I am also having this problem but i have not upgraded anything any DB experts out there able to give any ideas on how i can edit the query. In this particular case i just want to add an extra field that is being imported to excel.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"edit query" button in Excel 2007 has been hidden | Excel Worksheet Functions | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
How to write parameter query with "or is null" criteria | New Users to Excel | |||
"Invalid Web Query" error on opening a 2003 worksheet | Excel Discussion (Misc queries) | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) |