Re: Transferring a table to Oracle:

I bet your table names In Access are in mixed case. When you move them from Access to Oracle Access issues a statement like: create table "myTable" (....)
So there is a table called myTable. Then you issue a query like select * from mytable or select * from myTable and you get the error.
What gets sent to the back end is:
select * from MYTABLE;
Since the table name is "myTable" it does not find it.

I bet:
select * from "myTable" gets your results.

I bet if you rename your tables and columns to all upper in Access and then transfer it to Oracle things will work right. Jim
"Andoni OConchubhair" <andoni_at_staff.tutticom.com.NOSPAM> wrote in message news:3A0AE986.2A8AC079_at_staff.tutticom.com.NOSPAM...
> Hi,
>
> I am using Access 2000 and Oracle 8i (for Linux)
> I am trying to move a table over my ODBC connection from my Access
> database to my Oracle database.
>
> I have set up a working ODBC connection and this part works fine as I
> have linked all the table from my Oracle database into my Access
> database and I can see their info fine.
>
> I am following the steps in the Access help pages about transferring to
> oracle and I follow the steps with no problems at all.
> But: when I then go to my Oracle database and try to select from the
> table I have moved across it prevents me saying the table does not exist
> (not that it is empty). On the other hand there is an entry for the
> table's name in the user_tables table.
>
> Please help if you have seen this before etc. Any and all ideas are
> welcome.
>
> Thanks in advance,
> Andoni OConchubhair
>
Received on Sat Nov 11 2000 - 05:18:26 CET