Hi,

I am using microsoft excel 2002 , Oracel ODBC Driver ( 8.01.07.00) & trying
to connect to Oracle database 9i. it is getting connected fine . It shows
me a
list of public synonyms ( owner : ALL) along with tables,views,system tables.

but I can n't access public synonym from add table but strange thing that I
can access those public synonym from microsoft query , it returns data too.

Can somebody please help me

Regards
-- Sandeep