Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Can't edit SQL question in MS Excel/Query
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Guest, post: 2738114"] Hans I'm not sure about the MS Query icon you are talking about in the taskbar but the way I can get to MS Query using Excel 2000 and connectiong to Oracle database is choosing 'Data' followed by 'Get External Data', and then choosing 'Run saved query' or 'New database query' from the top menu selection in Excel. You can then choose either the 'Queries' tab or the 'Databases' tab in the 'Choose Data Source' box. In this box you have the option to use the Query Wizard to create/edit queries by checking or unchecking the checkbox. From here you can either edit a saved MS Query or create a new one and bring the data to Excel after connecting to Oracle using the ODBC driver Mand ----- Hans Blom wrote: ---- Hello I'm running Win2k SP3, Excel 2000 SP-1 and have created SQL questions that fetch data from an Oracle 8i DB via ODBC Sometimes (or actually quite often) I can't edit the SQL questions i MS Query. The MS Query icon just flashes in the taskbar and disappears Any wiz got any idea what can be done about it Regard Han [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Can't edit SQL question in MS Excel/Query
Top