Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: exporting to Oracle 7 from access

Re: exporting to Oracle 7 from access

From: wayne <no_at_email.please.com>
Date: 25 May 2001 04:26:20 GMT
Message-ID: <9ekmtc$5np@freepress.concentric.net>

> I tried already tried 'precreating' the table in in sql*plus and then
> exporting from access but I get an error that the table already
> exists.

Try this:

  1. Create the table in the right schema with SQL Plus
  2. Open Access and create a linked table object linking to the Oracle table
  3. Copy from the access table to the linked Oracle table.
Received on Thu May 24 2001 - 23:26:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US