Re: Export Oracle to Access

From: Michael Klanthe <dummy_at_dummy.com>
Date: Thu, 18 Mar 1999 14:13:09 +0100
Message-ID: <7cqu61$54t2@ppd00021.deutschepost.de>

Hi,

you must start SQL*Plus and write a SELECT Statement like this: SELECT row1,'|',row2,'|',row3,...,rown FROM table WHERE ....

This generates an output with | (pipe) as row-delimiter. If you before this statement starts the SPOOL <Filename> and then executes the statement, the output is in an ascii-File. This file can importet as text with delimiter in Access. There you have to set the delimiter '|'.

Michael

cvtruong_at_hotmail.com schrieb in Nachricht <36f08e17.13454446_at_90.0.0.1>...
>To All,
>I would to know how could I export an Oracle database to Access.
>Please advise,
>Thanks in advance.
Received on Thu Mar 18 1999 - 07:13:09 CST