Re: WANTED: Import utility for Access to Oracle

From: RYoung <ryoung_at_summer.dbsol.com>
Date: 1997/04/24
Message-ID: <01bc5065$18cf77a0$fa428ad0@pc060.groupZ.net>#1/1

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_at_flash.net> wrote in article <01bc502f$1296f7e0$22d0b5cf_at_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.
>
>
Received on Thu Apr 24 1997 - 00:00:00 CDT