Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing .dmp file to ms access

Re: Importing .dmp file to ms access

From: Roland Schaar <rschaar_at_gosch.com>
Date: Wed, 23 Jun 1999 11:27:53 +0100
Message-ID: <3770B6A8.3C5CC506@gosch.com>


you could spool the table to a CSV-file using SQL-PLUS

set linesize 1000
set pagesize 0
spool dummy.csv
select column1||'; '||column2||';'||column2||';' from xxxx; spool off

xventure_at_mbox3.singnet.com.sg wrote:

> Hi,
>
> I'm a newbie at oracle. I had exported some tables from oracle8 netware5
> platform. Is there any way I can import it to ms access or cenvert it to
> .csv format? Thanks in advance.
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Wed Jun 23 1999 - 05:27:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US