Export data (a student's question)

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 Thu Feb 04 1999 - 21:02:25 CST