Re: Attaching ODBC tables in excel

I ran into this problem as well and I found that if you simply edit the query using the sql tool then you can specify the tablespace name as before. You may also find that if the number of tables across all tablespaces is large, that although you can create the query in msquery it will not return data to excel.

Paula Zenti wrote in message <741a9l$2de$1_at_nntp3.uunet.ca>...
>Hi, can someone please help me with this question.
>
>I am running office97 and using msquery through excel to attach to ODBC
>tables.
>
>I have three tablespace names in oracle. Each tablespace have the same
>tables names. Therefore, I have one tablespace called, production, the
>second is called Test and the third is called Test2.
>
>When I am creating a query, I cannot see the tablespace name/owner (PROD,
>TEST, TEST3). Therefore, I see a list of tables, but it displays the same
>name 3 times, one for each tablespace.
>
>In the last version of excel I could select the owner/tablespace name, how
>can I select that option in excel97?
>
>Regards,
>
>
>Paula Zenti
>
>
Received on Tue Dec 01 1998 - 00:00:00 CST