Harald,

That was very helpful. I have another question though. How do I find out
what the server name is?? It comes up in the data sources and I usually just
pick it.

Sorry I'm very new to macros

Cheers,
Wags

"Harald Staff" wrote:

Hi Wags

Copy the SQL statement from Query (SQL button) and into a textfile or
wherever. Then try the approach described at http://tinyurl.com/6mwwv

HTH. Best wishes Harald


"Wags" skrev i melding
...
Hi,

I'm having trouble importing data from Oracle. I have set up queries in
microsoft query and they work fine, but they do not import in excel.
Excel
just sits there thinking then crashes. I'm using excel 2003. Any help
would
be great.

Thx,
Wags