From access you need to link the table first. What ever name that you use
(in access) is the table name that access sees.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Yimei Huang" <ymhuang_at_ccs.neu.edu> wrote in message
news:Pine.GSO.4.21.0005051516430.18749-100000_at_denali.ccs.neu.edu...
> Hi, all:
>
> I am trying to save(export) one table in access into oracle via
> odbc. I can see this table name by using:
>
> select table_name from user_tables;
>
> but when I do some sql, like "select * from c1", Then error message
> says: no this table or view...
>
> I just cannot understand why, I try many times, the result is the same
> thing.
>
> Can you give me some clues?
>
> thanks
>
Received on Sat May 06 2000 - 00:00:00 CDT
