Re: Exporting Oracle table to Access
From: Rensheng Chen <rchen_at_shiva.Hunter.CUNY.EDU>
Date: 1998/01/28
Message-ID: <Pine.SOL.3.91.980128120335.9606A-100000_at_shiva.hunter.cuny.edu>#1/1
Date: 1998/01/28
Message-ID: <Pine.SOL.3.91.980128120335.9606A-100000_at_shiva.hunter.cuny.edu>#1/1
A easy way to do it is link the tables you want export from Oracle to access by ODBC. Then you can treat these tables as of access tables. you can do append query to append the data from the linked oracle table to your existing access table.
hope it helps
Lou Chen
Data Warehouse project Oracle DBA
rchen_at_zyga.com
On 27 Jan 1998, Alphons Evers wrote:
> Could someone tell me how to export oracle tables to another format.
> (maybe tab delimited) I need to be able to use the tables with access.
>
> TIA
>
>
> --
> Alphons Evers
> Ontario MNDM
> Cartographic Unit
> reply to: evers_at_gov.on.ca
>
>
Received on Wed Jan 28 1998 - 00:00:00 CET