Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export data (a student's question)
Ya-Ling Huang wrote:
> Hi! I want to export my data from Oracle to Access. Here's my approach.
>
> 1. Transfer my Oracle data into ASCII files:
>
> Spool EMPLOEE.TXT
> Select * from EMPLOYEE;
> Spool off
>
> I successfully transferred my data into ASCII. However, it contains some
> message I don't need, like
>
Try to use SQL*Plus SET command:rem turn off printing of column headings
set heading off
rem turn off " .... rows selected" message
set feedback 0
rem turn off statements text printing
set echo off
rem turn off formfeed printing....
set pagesize 0
And read SQL*Plus User's Guide and Reference for details..... Dmitry Loginov
> SQL> set heading off
> SQL> select * from employee;
> 8 rows selected.
>
> Alos, when Access imports the data (Get exteranl data |Import), it shows
> the whole data on a single line.
>
> Can anyone help me? Thanks a lot.
>
> Ling
Received on Fri Feb 05 1999 - 02:49:20 CST