Re: ddl for access

ˇ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