Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export data (a student's question)
Hi
If you are using Access 97 it is very easy to export the data into Access.
what you have to do is
Step 1: create one access database
step 2 : Create a Machine datasource pointing to Oracle driver
step 3: now go to get external data option (you can import or link the table)
step4 : after step 3 choose in files of types as ODBC database
Step 5 : You will get select Data source page in that go to Machine data soucrce option and choose the name you have given in step 2.
step 6 : It will prompt for the username and password
Stp 7 : Then it show you the tables avilable in the database (You can choose)
Step 8 : select the table you want to import to Access and press ok . It will export the data to the database of access you are created in step 1.
Eswar
In article <Pine.SOL.4.03.9902042056210.4666-100000_at_sunburst.usd.ed>,
Ya-Ling Huang <yhuang_at_usd.edu> 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
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 05 1999 - 04:00:24 CST