Re: Transferring a table to Oracle:

Andoni,
I actually had the same problem. I finally grabbed the SQL script to create the table from Access and just created an empty table in Oracle.

Then, I linked the external Oracle table and just copy/pasted the records from Access into the linked Oracle table.

Hope that helps,
John

Andoni OConchubhair wrote:

> 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 - 01:33:23 CET