From: "RYoung" <ryoung@summer.dbsol.com>
Subject: Re: WANTED: Import utility for Access to Oracle
Date: 1997/04/24
Message-ID: <01bc5065$18cf77a0$fa428ad0@pc060.groupZ.net>#1/1
References: <01bc502f$1296f7e0$22d0b5cf@ultra2.teras.com>
Organization: dbsol
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools



Check the following:When  inside Oracle, place the table name inside double
quotes " " whenever you use it in a SQL statement. This works for Access
2.0.

Bruce Callen <bccallen@flash.net> wrote in article
<01bc502f$1296f7e0$22d0b5cf@ultra2.teras.com>...
> I am trying to import several tables, structure and data, from Access 95
 to
> Oracle 7.3.  I have tried using the export option on Access to ODBC (2.5)
> to Oracle.  This moves the table over with all the fields.  The problem
 is
> then if I try to set primary keys, add indexes or do anything Oracle says
> that it is not a Table/View.
> 
>