Re: ddl for access

Article View: comp.databases.ms-access

Article #342

Back to comp.databases.ms-access Previous Next

#342

From: Steve Arbaugh
Date: Mon, 12 Jul 1999 00:00

32 lines
2292 bytes

�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@cev.es> wrote in message
news:7mc7cu$p38$1@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.
>
>
>

Technical Details

Message-ID: <7meefq$kfk$1@nntp5.atl.mindspring.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7mc7cu$p38$1@diana.bcn.ttd.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 111a5a,45a71c34ec611a96
X-Google-Attributes: gid111a5a,public
X-Google-Thread: f5464,45a71c34ec611a96
X-Google-Attributes: gidf5464,public
X-Google-Thread: ff0ac,45a71c34ec611a96
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f99a8,45a71c34ec611a96
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 1142f6,45a71c34ec611a96
X-Google-Attributes: gid1142f6,public
X-Google-Thread: 10c7bc,45a71c34ec611a96
X-Google-Attributes: gid10c7bc,public
X-Google-Thread: 115acd,45a71c34ec611a96
X-Google-Attributes: gid115acd,public
X-Google-Thread: fa4f9,45a71c34ec611a96
X-Google-Attributes: gidfa4f9,public
From: "Steve Arbaugh" <75323.2112@nspm.compuserve.com>
Subject: Re: ddl for access
Date: 1999/07/12
Message-ID: <7meefq$kfk$1@nntp5.atl.mindspring.net>
X-Deja-AN: 500380056
References: <7mc7cu$p38$1@diana.bcn.ttd.net>
X-Priority: 3
X-Server-Date: 13 Jul 1999 04:14:50 GMT
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Organization: MindSpring Enterprises
X-MSMail-Priority: Normal
Reply-To: "Steve Arbaugh" <75323.2112@nspm.compuserve.com>
Newsgroups: comp.databases.ms-access,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,es.comp.bd.ms-access,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.externaldata,microsoft

Reply to Parent Message