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

Home -> Community -> Usenet -> c.d.o.server -> Re: ddl for access

Re: ddl for access

From: Steve Arbaugh <75323.2112_at_nspm.compuserve.com>
Date: Mon, 12 Jul 1999 23:14:48 -0500
Message-ID: <7meefq$kfk$1@nntp5.atl.mindspring.net>


ˇHola Pedro!

Have you tried using an ODBC connection to Access and running the ddl from oracle that way? Otherwise Access is not capable of reading SQL scripts.

HTH
--
Steve Arbaugh
ATTAC Consulting Group
http://ourworld.compuserve.com/homepages/attac-cg

Pedro Pablo Ramírez Estrela <pramirez_at_cev.es> wrote in message news:7mc7cu$p38$1_at_diana.bcn.ttd.net...
> Hi,
> i need to export an Oracle8 database to Access97.
> Oracle Designer can generate the DDL in various estandar DDL formats, but
i
> don't know the way Access can read from any of them.
> If is no such capability in Access, exists any add-in or utility that can
be
> employed to resolve this?
>
> The only way i know is to reconstruct by hand all the SQL script in an
> Access module but this is not an option when you have a large database
> model!
>
> Thanks in advance,
>
> Pedro.
>
>
>
Received on Mon Jul 12 1999 - 23:14:48 CDT

Original text of this message

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