Re: Import von ACCESS via ODBC

Hi Kay,
You may have fallen victim to the 'mixed case' problem...ACCESS does not translate the table name into upper case, and Oracle does not like mixed case table names ( at least SqlPlus doesn't) unless they are enclosed in quotes so try:

Select * from "Books";

In the future change the Access table name to all upper case before exporting...

hth,

Kay Schulz <kay_schulz_at_yahoo.com> wrote:

>Hi
>I tried to export an access table via the ODBC export
>feature into Oracle 8.1.5;
>I didn't get an error
>When I go into SQL*Plus and do
>select TABLE_NAME from ALL_TABLES;
>I see the two tables I wanted
>So I did
>select * from Books;
>Table or View not existing
>How can this be?
>If it would be empty, fine, but not existing while the other
>command told me it exists ....
>Weird.
>Please help
>Kay

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Apr 16 2001 - 12:22:04 CDT