Re: Export Oracle to Access

From: Mike Rose <mmrose_at_home.com>
Date: Fri, 19 Mar 1999 06:19:06 GMT
Message-ID: <u%lI2.10477$573.4520@news.rdc1.md.home.com>

Another option is to:
1) Install an ODBC driver for your version of Oracle. 2) Using the ODBC driver configuration utility, setup a DSN (Data Set Name) using the Oracle ODBC driver and the SQL*Net alias you would normally use to connect to the Oracle server.
3) In Access Import the tables from the Oracle database.

Mike Rose

Alan Johns wrote in message ...
>There is a tool from Princeton Softech, called Move for Servers, which
>will allow relational extracts of Oracle data (and ddl), and allow them
>to be inserted into an SQL Server based destination.
>
>If you would like any more info, please contact me on the below numbers.
>
>Thanks . Alan
>In article <36f08e17.13454446_at_90.0.0.1>, cvtruong_at_hotmail.com writes
>>To All,
>>I would to know how could I export an Oracle database to Access.
>>Please advise,
>>Thanks in advance.
>
>Best regards
>--
> Alan Johns
> Tarragon Software Ltd - UK & Ireland Distributor for
> Princeton Softech's -
> Upgrade 2000
> Ager 2000
> Relational Tools for DB2
> Move for Servers - Oracle, DB2, Sybase, SQL Server
> Version Merger
>
> ELISE - the Match in Matching.
> Software for recruitment, estate agencies,
> dating agencies, etc from WCC
>
>Phone: 44(0)1480 414141
> Fax: 44(0)1480 436869
Received on Fri Mar 19 1999 - 00:19:06 CST