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

This message: [ Message body ]
Next message: Thomas Kuchenbuch: "SQL*Net 2 and Win NT"
Previous message: Snorri Bergmann: "Re: PRESS:INFORMIX UNVEILS PRODUCT STRATEGY FOR UNIVERSAL SERVER"
In reply to: D.S. McNicholl: "Convert comma-seperated file to oracle DB"
Next in thread: Thomas Kuchenbuch: "SQL*Net 2 and Win NT"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message