Home » Infrastructure » Windows » Excel ODBC - Microsoft Query - slow with 10GR2
Excel ODBC - Microsoft Query - slow with 10GR2 [message #232327] Fri, 20 April 2007 03:04
Messages: 80
Registered: January 2006
Location: Luxembourg

after a successful upgrade from Oracle 8i to 10GR2 i recognized a very slow ODBC connection within Excel and Oracle.

We are using a lot the "Microsoft Query" function (Data-->import external data), which allows to refresh excel files easily.

This was working fine with Oracle 8i, but now it takes very long until you're able to create the SQL Query in Microsoft Query, because there are a lot of new tables which are loaded everytime.

Tables & information like:

These things haven't been loaded with 8i and of course, they aren't useful for "Microsoft Query". Is it maybe possible to tell "Microsoft Query" to not load these unecessary information?

thanks for any ideas that might point me to the right direction.

Excel: Version 2003, SP2
Oracle: 10GR2 (

[Updated on: Fri, 20 April 2007 03:05]

Report message to a moderator

Previous Topic: TNS-12547: TNS:lost contact error after Windows2003 SP1 upgrade
Next Topic: Attach timestamp to filename
Goto Forum:

Current Time: Thu Oct 27 22:02:06 CDT 2016

Total time taken to generate the page: 0.16666 seconds