Re: Convert comma-seperated file to oracle DB

From: Chris Fischer <cfischer_at_nando.net>
Date: 1996/03/18
Message-ID: <4ikm17$2l9_at_castle.nando.net>#1/1


"D.S. McNicholl" <eqr6mcnichd_at_grid.unl.ac.uk> wrote:

>Is there a way to convert a comma seperated file into an oracle
>databse ?

yes. Use SQL*Loader on the database server

>Is it possible to convert an access database into an oracle
>database ?

yes. Use ODBC in Access to attach the tables to the Access database. Then you can use an Append query to append rows from the access table to the oracle table that you've created to hold the data. Hope this points you in the right direction.

+------------------------------------------------------------+
| Chris Fischer                           cfischer_at_nando.net |
| Sr. Systems Analyst                    Work: (919)676-0062 |
| Toys "R" Us                                                |
+------------------------------------------------------------+
Received on Mon Mar 18 1996 - 00:00:00 CET

Original text of this message