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_at_nntp5.atl.mindspring.net>
Date: Mon, 12 Jul 1999 23:14:48 -0500
Message-ID: <7meefq$kfk$1_at_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...Received on Tue Jul 13 1999 - 06:14:48 CEST
> 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.
>
>
>