Re: Export data from Oracle 7 on unix?

One way to do it (and there are many) is to use ODBC. If you do that, then all you would need to do is have the Oracle 7 odbc drivers installed on the target pc and then do whatever you need to do to create an odbc link to the data on the unix server (presumably it is on the network). Then just write a simple routine to copy the data from the source table to a local table.

A second way is to use sqlplus to create some type of delimited flat file that you can import into Access. If you have columns like LONG or RAW that can be a problem - but that would be a problem no matter what approach you take because I think both of them have no equivelent in Access.

Ken

Phil Dennis wrote:
>
> Hi,
>
> I have a project coming up that involves exporting data from an oracle 7
> database running on a unix box and transferring it to ms-access on a PC.
>
> I have never used Oracle before. I expect that it will involve producing
> text files from the oracle database tables. What utilites and commands would
> I use to do this?
>
> I will be very grateful if someone can help me with this.
>
> Phil Dennis
>
> phil AT scsys.globalnet.co.uk
Received on Sun Jun 20 1999 - 14:14:24 CEST