MS Query instead of "Edit OLE DB Query"

C

Casey_van_Gorp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stop MS Query from connecting when starting 2
relative path in OLEDB string 2
Connection string - Query SQL Server with ADO 1
Parameter query issues, Excel 2003 3
Linking Access Query to Excel make DB Read Only 1
Deleting MS JET OLE DB references in an Excel 2003 file 1
Editing MS Query 0
Trouble with the ACE provider 0

Top