Re: Export data (a student's question)

Hi,

I am writing without looking up all the necessary syntax, so I might be off a bit. The SQL*PLUS User's Guide and Reference manual has all the details. (If you have a copy handy)

I don't know how all the settings needed, but...

How long is the output line in the ascii file? I believe SQL*PLUS defaults to 80.

To adjust for that you need the SET LINESIZE <number> command.

To remove page breaks, you need two commands: set newpage 0 and set pagesize 0.

To remove Headings, you would need: set heading off

To remove the message at the end, telling you how many rows were selected: set feedback off

Issue these commands BEFORE you issue the spool command.

I can't help you with the ACCESS problem, since I don't know ACCESS that well.

Hope this helps,

Manmohan

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
>
> 2. Load the ASCII file into an Access table.
>
> Here is my problem:
>
> I successfully transferred my data into ASCII. However, it contains some
> message I don't need, like
>
> 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 Tue Feb 09 1999 - 20:47:11 CST