Can't edit SQL question in MS Excel/Query

[Hans Blom]

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 in
MS Query. The MS Query icon just flashes in the taskbar and disappears.
Any wiz got any idea what can be done about it?

Regards

Hans

 

[Guest]

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

 

[Hans Blom]

Hello,
my problem is, I create a query exactly the way you describe, but after
I saved the query, I can never be certain that I can edit it at a later
time. It might work 4 times out of 10 or so. The other times as I said,
the MS Query icon just flashes in the taskbar and disappears and I'm
back staring dumbly at my EXCEL worksheet.

Hans