Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Junior Member
 
Posts: 5
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"edit query" button in Excel 2007 has been hidden Andre Ranieri Excel Worksheet Functions 2 May 2nd 23 03:44 AM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
How to write parameter query with "or is null" criteria Vincent Alliance New Users to Excel 0 April 8th 06 02:55 AM
"Invalid Web Query" error on opening a 2003 worksheet Linus Excel Discussion (Misc queries) 0 February 21st 06 04:55 PM
Pivot table "Show all data" query Laurence Lombard Excel Discussion (Misc queries) 2 January 31st 06 09:24 AM


All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"